ETL Step 6: KEYLOOKUP

In the KEYLOOKUP step, the system generates the primary key for all new records; that is, records in the *_XFRN tables are based on the value of MD_ENTERPRISE_KEY. The system also generates the primary key for late arriving data of referred entities. The mapping between MD_ENTERPRISE_KEY and the primary key is one to many because the system assigns a primary key to each history record.

*_XFRN tables are input in this step while *_ KEY_LOOKUP tables are output.

The following table lists the key staging tables.

Key Staging Tables

Table Name

Table Description

<TARGET_ENTITY_NAME>_DIM/FACT_KEY_LOOKUP

Contains mapping between MD_ENTERPRISE_KEY and PK_<TARGET_ENTITY_NAME>.

The KEY_LOOKUP table contains the following system reserved fields.

• System Reserved Fields in Staging Tables

Field Name

Field Description

PK_<TARGET_ENTITY_NAME>

Generated primary keys for new records