HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package to implement an incremental data load strategy.
The package reads rows from a source system and compares them to rows in a destination system. New rows will be
inserted and changed rows will be updated.
You have used a Lookup transformation and a Conditional Split transformation. The Lookup transformation joins the
source and destination table on the business key, and includes all columns from the destination table in the data flow
output. The Conditional Split transformation inspects the destination columns and directs data flow to either insert
new records or update existing records.
You need to configure the Lookup transformation to ensure that all records flow to the Conditional Split
transformation, regardless of whether the rows match an existing row in the destination table.
Which setting should you select? (To answer, select the appropriate option in the answer area.)