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.)
Select and Place:
Drag Drop You A 1 (70.5 KiB) Viewed 93 times
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!