Configuration Guide

10.3

Back Next

Enabling Delta Detection on Specific Columns

To enable delta detection for specific columns:

Start the Schema Manager.

Acquire a write lock.

Select the staging table that you want to configure.

The Staging Table Properties pane is displayed.

Select the

Enable delta detection

check box.

Select the

Detect deltas using specific columns

option.

A list of available columns is displayed.

Choose the columns that you want to use for delta detection and click

Add >

, or click

Add All >>

to add all the columns for delta detection.

When loading data to the staging table, if any column from the defined set has values different from the available previous load values, the row is treated as changed. If all columns from defined set are the same, the row is treated as unchanged. Columns that are not mapped are ignored.

Configuring Delta Detection for a Staging Table

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal