Multiple choice technology databases

If the sources are comming from homogeneous databases then which transformation is required to join the sources?

  1. Joiner

  2. Lookup

  3. Source Qualifier

  4. All
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

When sources come from homogeneous databases (same database type), the Source Qualifier transformation can join them at the source level using SQL. The Source Qualifier represents the data rows from a single source and can combine multiple sources from the same database connection into one SQL query. Joiner and Lookup are used when sources come from heterogeneous databases or when joining downstream in the pipeline.

Keep practicing — related questions