Bulk Load Tables

Overview

The following tables are generated while running bulk load jobs to stage data during the load. They are generated from metadata for the specific entity type. As attributes for an entity type are defined, columns are added to the tables. The tables are automatically deleted at the end of a successful load. If the load fails for any reason, the tables are not deleted and can be used for debugging purposes.

Sample Bulk Load Tables

Sample Bulk Load Tables
Name	Naming Convention	Description
Cluster Conditions Table	MDM_BULK_CC_<staging_id>	Table used to pre-load cluster condition data columns during a data load.
Entity Staging Table	MDM_BULK_ST_<staging_id>	Table used to stage data before updating the hub.
Staging Table	MDM_STAGING_<staging_id>	Table used to stage data before updating the hub.

The following columns are common to all the staging tables and transpose tables. These tables are further populated with columns representing the attributes defined for the entity type.

MDM_BULK_CC_<Staging_ID> Columns

These tables have the same structure as the MDM_<entity_type>_CC table for the entity type associated with staging ID of the particular load.

MDM_BULK_ST_<Staging_ID> Columns

These tables have the same structure as the MDM_<entity_type>_ST table for the entity type associated with staging ID of the particular load.

MDM_STAGING_<Staging_ID> Columns

These tables have the same structure as the MDM_STAGING table.

Last updated: April 19, 2017