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:

Explanation:
Ref: http://msdn.microsoft.com/en-gb/library/hh231004.aspx



Leave a Reply 1

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


CorvusAlpha

CorvusAlpha

Net with update mask