FACT AND DIMENSIONAL TABLES

A fact table contains the primary keys and collection of variables derived from dimensional table . Both fact and dimensional tables play different but important roles in data warehouse. Facts table contain numerical data background while Dimension table provides context and background information.. A fact table clearly shows clearly shows the progression or otherwise of a business using...