OBIA - Naming Convention

1 - About

OBIA object naming convention

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.

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.

Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Powered by ComboStrap