Skip to main content

Posts

Showing posts with the label Fact Tables

Oracle Business Intelligence Applications (OBIA) Fact Tables

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...