Home » Microsoft » 70-458 » 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
Correct Answer: DE
Explanation/Reference:
-- BURGOS - YES
The question is confused, I’m Not sure f the products was the same products (from different distributors, MERGE) or different products from differente distributors (UNION ALL). I answered equal this DUMP.
--BURGOS
According to these references, this answer looks correct.
References:
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