Data Architect Question:
Download Job Interview Questions and Answers PDF
Please explain what is dimensional modeling?
Answer:
Dimensional model consists of dimension and fact tables. Fact tables store different transactional measurements and the foreign keys from dimension tables that qualifies the data. The goal of Dimensional model is not to achieve high degree of normalization but to facilitate easy and faster data retrieval.
Download Data Architect Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What is role Playing Dimension? | Please explain semi Additive Measures? |