Data Warehousing Question:

Why fact table is in normal form?

Tweet Share WhatsApp

Answer:

The fact table consists of the Index keys of the dimension/look up tables and the measures. So whenever we have the keys in a table. That it implies that the table is in the normal form.

Download Data Warehousing PDF Read All 131 Data Warehousing Questions
Previous QuestionNext Question
What is Difference between E-R Modeling and Dimensional Modeling?What is junk dimension? What is the difference between junk dimension and degenerated dimension?