OBIA - Naming Convention
Table Types Used by the Oracle Business Analytics Warehouse
|Aggregate tables (_A)
|Contain summed (aggregated) data.
|Dimension tables (_D)
|Star analysis dimensions.
|Staging tables for Dimension (_DS)
|Tables used to hold dimension information that have not been through the final ETL transformations.
|Staging tables for Usage Accelerator (WS_)
|Tables containing the necessary columns for the ETL transformations.
|Dimension Hierarchy tables (_DH)
|Tables that store the dimension's hierarchical structure
|Dimension Helper tables (_DHL)
|Tables that store M:M relationships between two joining dimension tables.
|Staging tables for Dimension Helper (_DHLS)
|Staging tables for storing M:M relationships between two joining dimension tables.
|Fact tables (_F)
|Contain the metrics being analyzed by dimensions.
|Fact Staging tables (_FS)
|Staging tables used to hold the metrics being analyzed by dimensions that have not been through the ﬁnal ETL transformations.
|In Table Types
|_D, _DS, _FS, _G, _GS
|_D, _DS, _FS, _G, _DHL, _DHLS
|Language Independent Code. 1)
|_ID columns are used in _FS tables. They correspond to the _WID columns of the corresponding _F table.
|Indicator or Flag.
|_D, _DHL, _DS, _FS, _F, _G, _DHLS
|Identifier generated by Oracle Bl linking dimension and fact tables, except for ROW_WlD.
|_F, _A, _DHL
|Name corresponding to the code column (columns ending with _CODE)
|_D, _F, _A
|Long Description corresponding to the code column (columns ending with _CODE)
|_D, _F, _A
In the transactional database, list of value (LOV) information is stored with both language-independent and display values. A Language Independent Code column references the language-independent LOV, which may be different from the displayed value in both the transactional system and the data warehouse.