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 intwo 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 thecorrect
location in the answer area.)

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 intwo 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 thecorrect
location in the answer area.)

Answer:

Explanation:

According to these references, this answer looks correct.
References:
http://msdn.microsoft.com/en-us/library/ms141703.aspx
http://msdn.microsoft.com/en-us/library/ms141775.aspx
http://msdn.microsoft.com/en-us/library/ms141020.aspx
http://msdn.microsoft.com/en-us/library/ms140182.aspx



Leave a Reply 5

Your email address will not be published. Required fields are marked *


Dan

Dan

Merge Act like a union all in T-sql but you can provide only two input to this transformation which must be pre-sorted. For this case it says “package that imports UNSORTED data”. So the correct answer is: “Union All”

https://krgdgshmvoifejbdn.tumblr.com

https://krgdgshmvoifejbdn.tumblr.com

I like the helpful information you supply for your articles.
I’ll bookmark your weblog and check again right here regularly.
I’m slightly certain I will learn many new stuff right right here!
Good luck for the following!