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: 
Net with update mask: This mode is similar to the regular Net mode but it also adds boolean columns with the name pattern __$__Changed that indicate changed columns in the current change row.
0
0