After you finish mapping columns to the staging tables, you can configure audit trail and delta detection for the staging table data.

If you enable audit trail, the MDM Hub retains records in the raw table. The MDM Hub retains records for either the number of stage job runs or the retention period that you configure. All duplicate records in a landing table are present in the corresponding raw table. After the

MDM Hub

reaches the number of stage job runs or the retention period, for each stage job run, the

MDM Hub

preserves one record for each primary key of the source object. For example, if the retention that you configure is 2 stage job runs, in the first two stage job runs, the

MDM Hub

preserves all the duplicates for a primary key of the source object in the raw table. After the two stage job runs, the raw table retains one record for each primary key of the source object for each stage job run.

If you enable delta detection, the

MDM Hub

detects the records in the landing table that are new or updated and copies the records, unchanged, to the corresponding raw table. Otherwise, the

MDM Hub

copies the records to the target table.

To configure audit trail and delta detection, click the

Settings

tab.