5.1.2 Tables that are Part Of Staging

Dimension data is stored in the following set of tables:

• STG _<DIMENSION>_B_INTF: Stores leaf and node member codes within the dimension.
• STG_<DIMENSION>_ TL_INTF: Stores names of leaf and node and their translations.
• STG_<DIMENSION>_ ATTR_INTF: Stores attribute values for the attributes of the dimension.
• STG_<DIMENSION>_ HIER_INTF: Stores parent-child relationship of members and nodes that are part of hierarchies.
• STG_ORG_UNIT_B_INTF: Stores leaf and node member codes within the organization unit dimension.
• STG_ORG_UNIT_TL_INTF: Stores names of leaf and node and their translations for the organization unit dimension.
• STG_ORG_UNIT_ATTR_INTF: Stores attribute values for the attributes of the organization unit dimension.
• STG_ORG_UNIIT_HIER_INTF: Stores parent-child relationship of members and nodes that are part of hierarchies for the organization unit dimension.
• STG_HIERARCHIES_INTF: Stores master information related to hierarchies.

Data present in the above set of staging dimension tables are loaded into the following set of dimension tables.

• DIM_<DIMENSION>_ B: Stores leaf and node member codes within the dimension.
• DIM_<DIMENSION>_TL: Stores names of leaf and node and their translations.
• DIM_<DIMENSION>_ATTR: Stores attribute values for the attributes of the dimension.
• DIM_<DIMENSION>_HIER: Stores parent-child relationship of members and nodes that are part of hierarchies.
• REV_HIERARCHIES: Stores hierarchy related information.
• REV_HIERARCHY_LEVELS: Stores levels of the hierarchy.
• REV_HIER_DEFINITIONS: Stores definitions of the hierarchies.

Staging tables are present for all key dimensions that are configured within the OFSAAI framework. For any custom key dimension that is added by the Client, respective staging dimension tables like STG_<DIMENSION>_B_INTF, STG_< DIMENSION>_TL_INTF, STG_<DIMENSION>_ATTR_INTF, and STG_<DIMENSION>_HIER_INTF have to be created in the ERwin model.