In a Dataflow Gen2 merge, which join type excludes records present in the second dataset from the first?

In a Dataflow Gen2 merge, which join type excludes records present in the second dataset from the first?

• A. Inner join
• B. Left join
• C. Right join
• D. Left anti join

Answer: (D)

Left anti join returns only the rows from the first dataset that have no matching row in the second dataset. In a Dataflow Gen2 merge, this means you drop any record from the first input that finds a counterpart in the second input. For example, if the first dataset has records A, B, C and the second has B and D, the result will include A and C but not B. This differs from an inner join (only the matching pairs), a left join (all rows from the first with matching data from the second or nulls where there is no match), and a right join (all rows from the second with matches from the first).

Left anti join returns only the rows from the first dataset that have no matching row in the second dataset. In a Dataflow Gen2 merge, this means you drop any record from the first input that finds a counterpart in the second input. For example, if the first dataset has records A, B, C and the second has B and D, the result will include A and C but not B. This differs from an inner join (only the matching pairs), a left join (all rows from the first with matching data from the second or nulls where there is no match), and a right join (all rows from the second with matches from the first).