How should you develop the data flow?

DRAG DROP

You are developing a SQL Server Integration Services (SSIS) package that imports unsorted data into a data warehouse hosted on SQL Azure.

You have the following requirements:

• A destination table must contain all of the data in two source tables.

• Duplicate records must be inserted into the destination table.

You need to develop a data flow that imports the data while meeting the requirements.

How should you develop the data flow? (To answer, drag the appropriate transformation from the list of transformations to the correct location in the answer area.)

View Answer

Answer:

Explanation:

References:

http://msdn.microsoft.com/en-us/library/ms141703.aspx

http://msdn.microsoft.c om/en-us/library/ms141775.aspx

http://msdn.microsoft.com/en-us/library/ms141020.aspx

http://msdn.microsoft.com/en-us/library/ms140182 .aspx