Merge Join Transformation in SSIS
The Merge Join Transformation in SSIS performs SQL Joins such as Inner, Left Outer, Full Outer, and Right Outer (indirectly achieved by Swapping the tables) in Integration Services. The SSIS Merge Join Transformation is very useful for loading data into the Dimension tables in the Data Warehouse. NOTE: The Merge Join Transformation in SSIS will … Read more
