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.
Previous Question | Next Question |
Explain the main difference between Inmon and Kimball philosophies of data warehousing? | Explain What are Fact, Dimension, and Measure? |