business-intelligence

Difference between Fact table and Dimension table?

by

In Data Warehouse Modeling, a star schema and a snowflake schema consists of Fact and Dimension tables. Fact Table: It contains all the primary keys of the dimension and associated facts or measures(is a property on which calculations can be made) like quantity sold, amount sold and average sales. Dimension Tables: Dimension tables provides descriptive … Read more