Enterprise Data Warehouse Question:

Why fact table is in a normal form?

Enterprise Data Warehouse Interview Question
Enterprise Data Warehouse Interview Question

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.


Previous QuestionNext Question
Explain the main difference between Inmon and Kimball philosophies of data warehousing?Explain What are Fact, Dimension, and Measure?