Multiple choice technology

When implementing a homogeneous join with a Source Qualifier transformation, what is the default join type?

  1. Full outer join

  2. Left outer join

  3. Right outer join

  4. Inner join.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Source Qualifier transformations use inner join as the default join type. This means only rows that match the join condition from all sources are returned. You must explicitly specify a different join type (left outer, right outer, or full outer) if needed.

Keep practicing — related questions