Oracle Business Intelligence Applications (OBIA) Fact Tables Dimensionally modeled (star-schema designed) data warehouses are primarily made up of two types of tables – Fact and Dimension. Fact tables store the measurements generated by business events (# of orders, amount of dollars, etc.); and Dimension tables store the descriptive attributes that provide context to the measurements (product [product name], customer [customer type], date, etc.). This post describes the types of Fact tables found in Oracle Business Intelligence Applications (OBIA) data warehouse – Oracle Business Analytics Warehouse (OBAW). There will be future posts that describe in detail the other table types in OBIA (Dimension, Internal, etc.). The 5 types of Fact tables used in the OBAW are: Transactional Aggregate Cycle Lines Snapshot State Transition. The Transactional Fact Table is the main type of fact table. It stores the lowest-level of information from transactional sources. An e...
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.