Multiple choice technology web technology

What is the out put of Joiner Transformation, if we use Detail Outer Join

  1. All the rows from master and detail table

  2. Matching rows from detail table and all rows from master table

  3. Matching rows from master table and all rows from detail table

  4. Only matching from master and detail table
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Detail Outer Join returns all rows from the master table plus matching rows from the detail table. If no match exists in detail, NULLs are returned for detail columns. Master is the driving table in Joiner transformations - this is the table with fewer rows for optimal performance.

Keep practicing — related questions