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 CDC Source component has the following requirements:
The output must include metadata columns that indicate which source columns have
changed.
The output must return only one change row per source row that is modified in the current
CDC processing range.
You need to configure the CDC Source component.
Which CDC processing mode should you select? (To answer, configure the appropriate
option or options 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 CDC Source component has the following requirements:
The output must include metadata columns that indicate which source columns have
changed.
The output must return only one change row per source row that is modified in the current
CDC processing range.
You need to configure the CDC Source component.
Which CDC processing mode should you select? (To answer, configure the appropriate
option or options in the dialog box in the answer area.)

Answer:



Leave a Reply 0

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