Microsoft
70-458 · Question #133
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 D. CDC Splitter. See the full explanation below for the reasoning.
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
- AMerge Join
- BDQS Cleansing
- CPivot
- DCDC Splitter
How the community answered
(51 responses)- A8% (4)
- B12% (6)
- C2% (1)
- D78% (40)
Community Discussion
No community discussion yet for this question.