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.
|
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.
|
Field Name |
Field Description |
|---|---|
|
PK_<TARGET_ENTITY_NAME> |
Generated primary keys for new records |
