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 answer represents a complete solution. Choose all that apply.)
A . Slowly Changing Dimension
B . pivot
C . Lookup
D . Union All
E . Merge

View Answer

Answer: D, E