Configuration Guide

10.4

Back Next

Specify the Highest Reserved Key

The highest reserved key is the highest source system key. To ensure that the keys that the MDM Hub generates do not conflict with the source system keys, reserve the highest source system key. If you enable the option to preserve the source system keys, you can specify the highest source system key to use for the records.

Set the Highest Reserved Key to the upper boundary of the source system keys. To add a buffer to the expected range of source system keys, set the value of the highest reserved key to a value that is slightly higher than the upper boundary of the source system keys.

During the initial data load into a base object, the MDM Hub performs the following tasks:

Inserts the values from the PKEY_SOURCE_OBJECT column of the staging table into the ROWID_OBJECT column of the base object.

Sets the start value of the primary keys that it must generate to the value of the highest reserved key incremented by 1.

During subsequent data loads into a base object, the MDM Hub performs the following tasks:

For source systems for which you preserve source system keys, the MDM Hub inserts the values from the PKEY_SOURCE_OBJECT column of the staging table into the ROWID_OBJECT column of the base object.

The MDM Hub generates primary keys in the following scenarios:

Source system key is greater than the highest reserved key.

Source system key is not a numeric value.

For source systems for which you do not preserve source system keys, the MDM Hub generates primary keys.

Rename Saved Search

Table of Contents

Configuration Guide

Configuration Guide

Specify the Highest Reserved Key

Specify the Highest Reserved Key