Configuration Guide

Back Next

Preserve Source System Keys

During stage jobs, the

MDM Hub

can generate keys or use keys from the primary key column of a source system. The

MDM Hub

can preserve the source system keys for one source system for the initial data load.

You can specify whether the

MDM Hub

must use key values from the source system or use the key values that the

MDM Hub

generates. Enable the

Preserving Source System Keys

option to use key values from the source system. Disable to use the key values that the

MDM Hub

generates. Default is disabled.

You can enable the option to preserve source system keys before you run the stage job. If you enable the option, the

MDM Hub

does not generate an internal key but instead uses the primary keys from the source system during the stage job. When you run the load job, the

MDM Hub

takes the value from the PKEY_SOURCE_OBJECT column of the staging table and inserts it into the ROWID_OBJECT column in the target base object.

You cannot change the setting to preserve source system keys after the base object is loaded.