Table of Contents

Search

  1. Introduction
  2. Configuring Hub Console Tools
  3. Building the Data Model
  4. Configuring the Data Flow
  5. Executing Informatica MDM Hub Processes
  6. Configuring Application Access
  7. MDM Hub Properties
  8. Viewing Configuration Details
  9. Search with Solr
  10. Row-level Locking
  11. MDM Hub Logging
  12. Table Partitioning
  13. Collecting MDM Environment Information with the Product Usage Toolkit
  14. Glossary

Specify the Highest Reserved Key

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.

0 COMMENTS

We’d like to hear from you!