OBIA - Naming Convention

> Oracle Business Intelligence Application (OBIA)

1 - About

3 - Suffixes

3.1 - Table

Table Types Used by the Oracle Business Analytics Warehouse

Table Suffix Description
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 final ETL transformations.
Advertising

3.2 - Column

Suffix Description In Table Types
_CD Code field _D, _DS, _FS, _G, _GS
_DT Date field _D, _DS, _FS, _G, _DHL, _DHLS
_I Language Independent Code. 1) _D, _MD
_ID _ID columns are used in _FS tables. They correspond to the _WID columns of the corresponding _F table. _FS
_FLG Indicator or Flag. _D, _DHL, _DS, _FS, _F, _G, _DHLS
_WID Identifier generated by Oracle Bl linking dimension and fact tables, except for ROW_WlD. _F, _A, _DHL
_NAME Name corresponding to the code column (columns ending with _CODE) _D, _F, _A
_DESC Long Description corresponding to the code column (columns ending with _CODE) _D, _F, _A
1)
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.