PrepAway - Latest Free Exam Questions & Answers

Which data flow transformation should you use?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
Audit

B.
DQS Cleansing

C.
CDC Splitter

D.
Pivot

2 Comments on “Which data flow transformation should you use?


Leave a Reply