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 data explanation. The table lines at the center of dimensional table in a fact table. Also, it usually contains two types of columns, measures and foreign keys. The measures contain quantitative data usually in the form of numeric values A dimension table on the other hand is used in data warehousing and business intelligence . It stores descriptive attributes related to a specific business domain such as time , geography or products. It is used for efficient querying, reporting and analytics..ASSIGNMENT 2SNOWFLAKE SCHEMA  is a type of multidimensional model which is used for a data warehouse. In this type of schema, the fact table and the dimension tables are contained. It then formed a snowflake with the fact table , dimension table as well as the sub dimensional table A STAR SCHEMA on the other hand is also a multidimensional model used in data warehousing. In this model, fewer key join is used . A star schema uses more space but a snowflakes uses less space. A star schema takes less time for querying but a snowflakes takes more time . Lastly, a snowflake design is a complex while Star schema is simple..