You are creating a SQL Server Integration Services (SSIS) package to retrieve product data from two different sources. O

[answerhappygod]

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
F. Slowly Changing Dimension
G. pivot
H. Lookup