You are developing a SQL Server Integration Services (SSIS) package to implement an
incremental data load strategy. The package reads data from a source system that uses the
SQL Server change data capture (CDC) feature.
You have added a CDC Source component to the data flow to read changed data from the
source system.
You need to add a data flow transformation to redirect rows for separate processing of
insert, update, and delete operations.
Which data flow transformation should you use?
A.
DQS Cleansing
B.
Merge Join
C.
Pivot
D.
Conditional Split
D
D
Of the answers given it would be a conditional split. A more correct answer unique to 2012/14 is the CDC Splitter on the Data Flow Page.
Agree with more. D would be by lack of a better answer