ETL Step 9: HIERARCHY

If a dimension entity has hierarchy definition in the target entity JSON, the system creates a hierarchy table in the HIERARCHY step. If no hierarchy is defined, this step is skipped. The hierarchy table supports unlimited hierarchy levels. The history of hierarchy changes is also kept for future reference.

DIM_* tables are input in this step while BRIDGE_HIERARCHY_* tables are output.

The following table lists the key staging table.

Key Staging Table

Table Name

Table Description

BRIDGE_HIERARCHY_<TARGET_ENTITY_NAME>

Stores the dimension hierarchy level information