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:

Explanation:



Leave a Reply 1

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