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
Explanation:
Reference:
http://msdn.microsoft.com/en-us/library/ms141703.aspx
http://msdn.microsoft.com/en-us/library/ms141775.aspx
http://msdn.microsoft.com/en-us/library/ms141020.aspx
http://msdn.microsoft.com/en-us/library/ms141809.aspx
http://msdn.microsoft.com/en-us/library/ms137701.aspx