DATA WAREHOUSE Questions and Answers

What is Dimensional Modelling?

Dimensional Modelling is a design concept used by many data warehouse designers to build their 
data warehouse. In this design model all the data is stored in two types of tables – Facts table and Dimension table. Fact table contains the facts/measurements of the business and the dimension table contains the context of measurements i.e., the dimensions on which the facts are calculated.