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...
A highly motivated, ambitious attorney with commercial litigation and corporate law experience as well as strong analytical and interpersonal skills. Adept at conducting legal research, analyzing and developing arguments, drafting legal documents, arguing at hearings, and preparing cases for trial. Reputation for having a great work ethic and being an excellent team player. Licensed in Texas, Florida, and New Jersey.