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.)

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:
According to these references, this answer looks correct.
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/en-us/library/ms137701.aspx



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Howie

Howie

D.
Union All

E.
Merge