• PRODUCTS
  • SUPPORT
  • DOCS
  • PARTNERS
  • COMPANY
  • QUOTE
  • ACCOUNT
  • STORE
QUOTE

Documentation

Support Forums
What can we help you with?
Topics

Enum CdcProcessingMode

Namespace:
Varigence.Languages.Biml.Transformation
Assembly:
Biml.dll
C#
    public enum CdcProcessingMode
    
  

Fields

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.

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.

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.

© Varigence