HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package. The data source for the data flow
task is a table that has been configured as a change data capture (CDC) table. You are using a CDC
Source component to obtain the CDC data.
The data source will be polled once per hour. The data is updated with multiple important status
changes per minute.
For each captured data change, the before and after values must be included.
You need to configure the CDC Source component.
Which CDC processing mode should you select? (To answer, configure the appropriate option in the
dialog box in the answer area.)
Which CDC processing mode should you select?
HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package. The data source for the data flow
task is a table that has been configured as a change data capture (CDC) table. You are using a CDC
Source component to obtain the CDC data.
The data source will be polled once per hour. The data is updated with multiple important status
changes per minute.
For each captured data change, the before and after values must be included.
You need to configure the CDC Source component.
Which CDC processing mode should you select? (To answer, configure the appropriate option in the
dialog box in the answer area.)
All with old values