You are developing a SQL Server Integration Services (SSIS) package to insert new data into a data mart. The
package uses a Lookup transformation to find matches between the source and destination. The data flowhas
the following requirements:
New rows must be inserted.
Lookup failures must be written to a flat file.
In the Lookup transformation, the setting for rows with no matching entries is set to Redirect rows tono match
output. You need to configure the package to directdata into the correct destinations. How should youdesign
the data flow outputs? (To answer, drag the appropriate transformation from the list of answer optionsto the
correct location in the answer area.)
Answer:
Explanation:
References:
http://msdn.microsoft.com/en-us/library/ms141821.aspx
http://msdn.microsoft.com/en-us/library/bb895366.aspx
OLE DB Source Output to “Lookup Transformation Task”
Lookup No Match Output to “OLE DB Destination”
Lookup Error Output to “Flat File Destination”
The correct answer is:
OLE DB Source Output to “Lookup Transformation Task”
Lookup Match Output to “OLE DB Destination”
Lookup No Match Output to “Flat File Destination”
I agree.
I agree with EL, hey howie stop your copy and paste
The correct answer is:
1/ OLE DB Source Output (As the name of the object is ‘OLE DB Source’)
2/ Lookup No Match output as we need to record only the new rows, we don’t care about the existing ones. In addition the Lookup transformation is set to redirect rows with no matching entries to No Match output.
3/ Lookup Error Output as any lookup failure must be written in a flat file
Agreed with TBiMac the given Answer/Explaination is CORRECT.
The requirement says “new rows must be inserted” the no match rows are the new rows therefore they must be inserted to the OLE DB Source.
Howie’s been wrong once and corrected himself. I don’t think its copy paste