CdcProcessingMode Enumeration

The CDC Processing Mode enumeration provides options for the rows that should be returned by a CDC Source component.

Enumeration Values

Name	Summary
All	Specifies that all changes in the current CDC context, except Before Update values, should be output by the CDC Source.
AllWithOldValues	Specifies that all changes in the current CDC context, including Before Update values, should be output by the CDC Source. For each update operation in the CDC result set, there will be two rows - one reflecting values before the update and one reflecting values after the update.
Net	Specifies that a single row should be output by the CDC Source for each modified table row, even if that row was modified multiple times in the processing range.
NetWithUpdateMask	Specifies that a single row should be output by the CDC Source for each modified table row, even if that row was modified multiple times in the processing range. Additionally, this mode provides __${ColumnName}__Changed boolean output column for each CDC column that indicates if that column was modified in the current row.
NetWithMerge	Specifies that a single row should be output by the CDC Source for each modified table row, even if that row was modified multiple times in the processing range. Additionally, in this mode Insert and Update operations are also merged into a single row that reflects an Upsert or Merge operation.