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
Difference between merge and merge join
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/4c994ffa-4b96-461f-8472-0139e7f5e3b8/merge-vs-merge-join-in-ssis?forum=sqlintegrationservices
hello!,I really like your writing so much! share we keep in touch more about your post on AOL? I require an expert on this space to solve my problem. May be that is you! Looking ahead to look you.
http://Www.Myseattleparty.com/redirect.php?url=http://elescuderofiel.com/index.php/component/k2/itemlist/user/77078
Attractive part of content. I simply stumbled upon your blog and in accession capital to claim that I acquire in fact enjoyed account your weblog posts. Any way I’ll be subscribing for your augment or even I achievement you access constantly quickly.
http://www.grindorgohome.com/forums/member.php?u=615082-FidelDupuy
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”
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!