Configuration Guide

10.4 HotFix 1

Back Next

Enabling Delta Detection for a Staging Table

To enable delta detection for a staging table:

Start the Schema Manager.

Select the staging table that you want to configure.

Acquire a write lock.

Select (check) the

Enable delta detection

check box to enable delta detection for the table. You might need to scroll down to see this option.

Specify the manner in which you want to have deltas detected.

Option	Description
Detect deltas by comparing all columns in mapping	All columns are selected for delta comparison, including the Last Update Date.
Detect deltas via a date column	If your schema has an applicable date column, choose this option and select the date column you want to use for delta comparison. This is the preferred option in cases where you have an applicable date column.

Specify whether to allow staging if a prior duplicate was rejected during the stage process or load process.

Select (check) this option to allow
the duplicate record being staged, during this next stage process execution, to bypass delta detection if its previously-staged duplicate was rejected.

If this option is enabled, and a user in the Batch Viewer clicks the

Clear History

button while the associated stage job is selected, then the history of the prior rejection (that this feature relies on) will be discarded because the records in the REJ table will be cleared the next time the stage job is run.

Clear (uncheck) this option (the default) to prevent the duplicate record being staged, during this next stage process execution, from bypassing delta detection if its previously-staged duplicate was rejected. Delta detection will filter out any corresponding duplicate landing record that is subsequently processed in the next stage process execution.

Rename Saved Search

Table of Contents

Configuration Guide

Configuration Guide

Enabling Delta Detection for a Staging Table

Enabling Delta Detection for a Staging Table