Oracle Business Analytics Warehouse
tables use a three-part naming convention: PREFIX_NAME_SUFFIX,
|
Part
|
Meaning
|
Table Type
|
|
PREFIX
|
Shows Oracle Business
Analytics-specific data warehouse application tables.
|
W_ = Warehouse
|
|
NAME
|
Unique table name.
|
All tables.
|
|
SUFFIX
|
Indicates the table type.
|
_A = Aggregate _D = Dimension _DEL = Delete _DH = Dimension Hierarchy _DHL = Dimension Helper _DHLS = Staging for Dimension Helper _DHS = Staging for Dimension Hierarchy _DS = Staging for Dimension _F = Fact _FS = Staging for Fact _G, _GS = Internal _H = Helper _HS = Staging for Helper _MD = Mini Dimension _PE = Primary Extract _PS = Persisted Staging _RH = Row Flattened Hierarchy _TL = Translation Staging (supports multi-language support) _TMP = Pre-staging or post-staging temporary table _UD = Unbounded Dimension _WS = Staging for Usage Accelerator |
No comments:
Post a Comment