Data Warehouse Manager Question:

Download Job Interview Questions and Answers PDF

Explain what is dimensional modeling?

Warehouse Manager Interview Question
Warehouse Manager Interview Question

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.

Ralph Kimball is one of the strongest proponents of this very popular data modeling technique which is often used in many enterprise level data warehouses.

Download Warehouse Manager Interview Questions And Answers PDF

Previous QuestionNext Question
Tell me what are Aggregate tables?Explain me what are the key columns in Fact and dimension tables?