Câu 69: 70-463: MCSA Implementing a Data Warehouse with Microsoft SQL Server 20122014

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

1. A. Multicast
2. B. Merge Join
3. C. Term Extraction
4. D. union All — đáp án hiện tại
5. E. Merge — đáp án hiện tại
6. F. Slowly Changing Dimension
7. G. pivot
8. H. Lookup