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.)
A.
Multicast
B.
Merge Join
C.
Term Extraction
D.
union All
E.
Merge
Explanation:
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/ms141809.aspx
http://msdn.microsoft.com/en-us/library/ms137701.aspx
“Each source contains products for different distributors” means each table has different data sets and need to be merged: Use ‘Merge’ and ‘Union All’ transformations.
0
0
D & E
0
0
Yes I agree with D & E. I was also thinking B (Merge Join) can be one of the answers too. If I am wrong please clarify for me.
The Merge Join transformation provides an output that is generated by joining two sorted datasets using a FULL, LEFT, or INNER join.
https://docs.microsoft.com/en-us/sql/integration-services/data-flow/transformations/merge-join-transformation?view=sql-server-2017
0
0