Enterprise Data Warehouse Question:
Download Questions PDF

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.

Download Enterprise Data Warehouse Interview Questions And Answers PDF

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