Mock Question: Union

[Lina Hussein]

One of the questions in the My mock is:

How would you simulate the Union Operator using SSIS?

Please check The attached screen shots  2 ways of achieving this approach:

• first using Union ALL the Sort 

          By using Union All then the output will be entered to a sort transformation and with in the Sort check the Option: Remove Rows with duplicate row values      

          that works like the Distinct in T-SQL

• second using Merge then Sort : then check the Option: Remove Rows with duplicate row values

--
Lina Hussein