70-463 · Question #234
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…
The correct answer is C. CDC Splitter. 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
Question
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?
Options
- AAudit
- BDQS Cleansing
- CCDC Splitter
- DPivot
How the community answered
(49 responses)- A16% (8)
- B4% (2)
- C71% (35)
- D8% (4)
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
Topics
Community Discussion
No community discussion yet for this question.