Configuration Guide

10.3 HotFix 3
- 10.5 HotFix 2
- 10.5
- 10.4 HotFix 3
- 10.4 HotFix 2
- 10.4 HotFix 1
- 10.4
- 10.3 HotFix 2
- 10.3 HotFix 1
- 10.3

Back Next

Highest Reserved Key Example

You preserve the source system keys for a staging table and set the highest source system key to use for the records to 100. You load more records from the staging table for which you preserved the source system keys. You then load records from a staging table other than the one for which you preserved the source system keys.

You can observe the changes to the key values in the ROWID_OBJECT column during each of the following load operations:

Initial data load with primary source system keys 20, 21, and 22 from the staging table for which you preserve the source system keys.

The MDM Hub loads three records to the associated base object with the ROWID_OBJECT values 20, 21, and 22.

After the initial data load, load five records with primary source system keys from the staging table for which you preserve the source system keys. The primary source system keys for the records are 23, 24, and 25, AB, and YZ.

The MDM Hub loads five records to the associated base object with the ROWID_OBJECT values 23, 24, 25,101 and 102.

Load three records with any primary key from a staging table for which you do not preserve the source system keys.

The MDM Hub loads three records to the associated base object with the ROWID_OBJECT values from 103 to 105.

Rename Saved Search

Table of Contents

Configuration Guide

Configuration Guide

Highest Reserved Key Example

Highest Reserved Key Example