About
Articles Related
Suffixes
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 |
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.