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

In a Detail Outer Join, all rows from the Master table are preserved, and only matching rows from the Detail table are included. Non-matching detail rows are discarded, while unmatched master rows are retained with null values for detail columns.

Keep practicing — related questions