Configuration Guide

10.5

Back Next

Staging Table Properties

You can create and manage staging tables through the

Hub Console

. You configure some staging table properties when you create a staging table.

The following table describes the staging table properties that you configure when you create a staging table:

Property	Description
Display Name	Name of the staging table as it appears in the Hub Console .
Physical Name	Name of the staging table in the database. The MDM Hub suggests a physical name for the staging table based on the display name that you enter.
Data Tablespace	Name of the data tablespace for the staging table.
Index Tablespace	Name of the index tablespace for the staging table.
Description	Description of the staging table.
Table type	Type of table. Default is Staging .
Create Date	Date the staging table was created.
System	Source system of the staging table data.
Preserve Source System Keys	Specifies whether the MDM Hub must use key values from the source system or use the key values that the MDM Hub generates. Enable to use key values from the source system. Disable to use the key values that the MDM Hub generates. Default is disabled. During the stage process, if multiple records contain the same PKEY_SRC_OBJECT, the surviving record is the one with the most recent LAST_UPDATE_DATE. The other records are sent to the reject table.
Fill on gap	Specifies whether contiguity between the effective dates of record versions is maintained when you add new record versions. If enabled, when you can add a new record version to the base object, the MDM Hub maintains the contiguity between effective periods of record versions. If not enabled, the MDM Hub rejects any addition of record version that breaks the contiguity between effective periods of record versions. Default is disabled.
Highest Reserved Key	Number by which the key must increase after the first load. The property appears if you enable the Preserve Source System Keys check box.
Cell Update	Enables the MDM Hub to update the cell in the target table if the value in the incoming record from the staging table is the same.
Columns	Columns in the staging table.

Rename Saved Search

Table of Contents

Configuration Guide

Configuration Guide

Staging Table Properties

Staging Table Properties