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.)
Answer: 