Data Warehousing Question: Download Questions PDF
"A dimension table is wide but the fact table is deep," Explain the statement in your own words.
![Data Warehousing Interview Answer Data Warehousing Interview Question](https://globalguideline.com/public/images/interview/24.png)
Answer:
Dimension table has got all the detail in formations of their respective table ,for egg, customer dimension table will contain all the related info about customers whereas fact table contains the main data, which contains the surrogate keys of every dimension; along with other measures.
Download Data Warehousing Interview Questions And Answers
PDF
Previous Question | Next Question |
What is the difference between aggregate table and materialized view? | What is a data profile? |