Mapping to summarize data

If you want to accumulate or deduct numerical values on the target, then map your source and target tables using the Summarization mapping type.

There are two types of summarization: Accumulation and Deduction. Accumulation ensures that numeric changes applied to the target column are directly proportional to changes applied to the corresponding source columns. Deduction ensures that numeric changes applied to the target columns are inversely proportional to changes applied to mapped source columns.

Columns used for summarization should not contain null values. If CDC Replication does encounter a null value during summarization this will not be considered an error and replication will continue. CDC Replication will ensure that it generates a data value that can fit in the target summarization column but performance considerations will affect that value so that you cannot rely on any specific relationship between the source column and the generated value.