070-458 Free Dumps Study Materials
Question 10: 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. Pivot
B. Merge
C. Audit
D. CDC Splitter
Correct Answer: B
Explanation:
MERGE with Incremental Loads The change data capture functionality that is new in SQL Server
2008 makes it easier to perform incremental loads reliably to a data warehouse. As an alternative to
using parameterized OLE DB Command transformations to perform the inserts and the updates, you
can use the MERGE statement to combine both operations.