Skip to main content

Posts

Showing posts with the label OBAW

Oracle Business Analytics Warehouse (OBAW) Table Types & Descriptions

Oracle Business Analytics Warehouse (OBAW) Table Types & Descriptions Oracle Business Intelligence Applications are driven by a data warehouse (Oracle Business Analytics Warehouse – OBAW) the stores transformed and aggregated data from the many sources that the application supports.  This post describes the various types of tables that make up the OBAW – how they are used and how to identify them. Table Type Table   Prefix Table Type Description Aggregate Tables _A Contain summed data Dimension tables _D Star analysis dimensions Delete tables _DEL Tables that store the IDs of the   entities that were physically deleted from the source system and should be   flagged as deleted from the data warehouse. 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 f...