Naming Conventions for Oracle Business Analytics Warehouse Tables

Oracle Business Analytics Warehouse tables use a three-part naming convention: PREFIX_NAME_SUFFIX.

Part Meaning Table Type

PREFIX

Shows Oracle Business Analytics Warehouse-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