DRAG AND DROP
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:
According to these references, this answer looks correct.
References:
http://msdn.microsoft.com/en-us/library/ms141821.aspx
http://msdn.microsoft.com/en-us/library/bb895366.aspx
This is incorrect, On the left side should be Match Output, and in the right side No Match Output (because of the setting to Redirect rows to the no match output)
No, it’s correct. The requirements are “..New rows must be inserted.” so Lookup no Match Output because if the files matching are inserted already. The other requirement is “..Lookup failures must be written to a flat file.” and lookup failures are lookup error output.
Same opinion
Agree.
It says “The package uses a Lookup transformation to find matches between the source and destination” and “the setting for rows with no matching entries is set to Redirect rows to no match output”.
So, if there wasn’t a match (i.e., if it is a new row), it will be outputted in ‘No match output’. And if there is an error, it should be outputted to the flat file.