What are Slowly Changing Dimensions?

Slowly Changing Dimensions (SCD) – dimensions that change slowly over time, rather than changing on regular schedule, time-base. In Data Warehouse there is a need to track changes in dimension attributes in order to report historical data. In other words, implementing one of the SCD types… Read More

Difference between Fact table and Dimension table?

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… Read More