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.
Audit
B.
Merge Join
C.
Merge
D.
CDC Splitter
Explanation:
The CDC splitter splits a single flow of change rows from a CDC source data flow into
different data flows for Insert, Update and Delete operations
Ref: http://msdn.microsoft.com/en-us/library/hh758656.aspx