Enterprise Data Warehouse Question:

Why fact table is in a 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 Enterprise Data Warehouse PDF 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?