Enterprise Data Warehouse Question:

Why fact table is in a normal form?

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.

Read All 13 Enterprise Data Warehouse Questions
Previous QuestionNext Question
Explain the main difference between Inmon and Kimball philosophies of data warehousing?Explain What are Fact, Dimension, and Measure?