Search This Blog

Sunday 16 December 2012

OBIA - Naming Convention


Table

Table Types Used by the Oracle Business Analytics Warehouse
Table SuffixDescription
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

SuffixDescriptionIn Table Types
_CDCode field_D, _DS, _FS, _G, _GS
_DTDate field_D, _DS, _FS, _G, _DHL, _DHLS
_ILanguage 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
_FLGIndicator or Flag._D, _DHL, _DS, _FS, _F, _G, _DHLS
_WIDIdentifier generated by Oracle Bl linking dimension and fact tables, except for ROW_WlD._F, _A, _DHL
_NAMEName corresponding to the code column (columns ending with _CODE)_D, _F, _A
_DESCLong Description corresponding to the code column (columns ending with _CODE)_D, _F, _A

No comments:

Post a Comment