Enterprise Data Warehouse Question:
Download Job Interview Questions and Answers 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 Question | Next Question |
Explain the main difference between Inmon and Kimball philosophies of data warehousing? | Explain What are Fact, Dimension, and Measure? |