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