Enterprise Data Warehouse Question:

Download Job Interview Questions and Answers PDF

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.

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?