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