OBIA - Naming Convention

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.

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