Which transformation types should you use?

You are creating a SQL Server Integration Services (SSIS) package to retrieve product data from two different sources. One source is hosted in a SQL Azure database. Each source contains products for different distributors.

Products for each distributor source must be combined for insertion into a single product table destination.

You need to select the appropriate data flow transformation to meet this requirement.

Which transformation types should you use? (Each correct answer presents a complete solution. Choose all that apply.)
A . Multicast
B . Merge Join
C . Term Extraction
D . union All
E . Merge

View Answer

Answer: D, E

Explanation:

Reference: http://msdn.microsoft.com/en-us/library/ms141703.aspx

Reference: http://msdn.microsoft.com/en-us/library/ms141775.aspx

Reference: http://msdn.microsoft.com/en-us/library/ms141020.aspx

Reference: http://msdn.microsoft.com/en-us/library/ms141809.aspx

Reference: http://msdn.microsoft.com/e n-us/library/ms137701.aspx