Câu 43: 70-463: MCSA Implementing a Data Warehouse with Microsoft SQL Server 20122014

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?

1. A. DQS Cleansing
2. B. Conditional Split — đáp án hiện tại
3. C. Audit
4. D. Merge