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