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.)

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.)

Answer:



Leave a Reply 1

Your email address will not be published. Required fields are marked *


CorvusAlpha

CorvusAlpha

All with old values