In this video, we will try to understand what is a fact table and dimension table. Measurements, facts, and dimensions are basic building blocks of data warehousing and in this video, we will understand how to categorize data into a fact table and into a dimension table, and we will also look at the difference between a fact table and a dimension table.
Facts are measurements, numeric and quantifiable values, Dimensions on the other hand give context to these values.
Content and video created by - Kishan Mashru
- Fact table and Dimension table | Data Warehousing ( Download)
- What is Dimension and Fact in Data Warehouse ( Download)
- What is STAR schema | Star vs Snowflake Schema | Fact vs Dimension Table ( Download)
- Difference Between Fact Table and Dimension Table - Interview questions ( Download)
- What are Dimensions and Measures ( Download)
- Dimensions & Measures – Simplest explanation you have ever heard ( Download)
- Master Dimensional Modeling Lesson 01 - Why Use a Dimensional Model ( Download)
- Dimension & Fact Tables ( Download)
- Episode#19: Data Vault Modelling @letstalkaboutdata ( Download)
- Data Modeling Tutorial: Star Schema (aka Kimball Approach) ( Download)
- Fact vs Dimension Table - Real time Use-Case ( Download)
- What is Grain in Data warehouse ( Download)
- What are Types Of Dimension | Data Warehouse Tutorial | Data Warehouse Concepts (12/30) ( Download)
- FACT & Dimension Tables - Data Warehousing Fundamentals ( Download)
- Why Conformed Dimension is so important | Data Warehouse Concepts ( Download)
