Interview Question of the Week #041 – What is a Merge Join?
Question: What is a Merge Join? Answer: The Merge Join transformation provides an output that is generated by joining two sorted data sets using a FULL, LEFT, or INNER join. The Merge Join transformation requires that both inputs be sorted and that the joined columns have matching meta-data. The user cannot…
Read More