5.9.3 Loading Data from STG_INTF Tables to DIM_INTF Tables

The following tables 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_HIERARCHIES_INTF - Stores master information related to hierarchies. Data present in the above set of staging dimension tables are loaded into the below 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.

For more information on viewing the structure of staging tables, refer to the Oracle Financial Services Analytical Applications Data Model Data Dictionary.

Staging tables are present for all key dimensions that are configured within the OFSAAI framework. The Dimension IDs used for key dimensions are:

Table 5-8 The Dimension IDs used for the key Dimensions

Dimension ID	Dimension Table	Staging Tables
1	DIM_ORG_UNIT	STG_ORG_UNIT_**_INTF
2	DIM_GL_ACCOUNT	STG_GL_**_INTF
3	DIM_COMMON_COA	STG_COMMON_COA_**_INTF
4	DIM_PRODUCT	STG_PRODUCTS_**_INTF
5	DIM_ORG_STRUC- TURE	STG_LEGAL_ENTITY_**_INTF