Data Warehousing Question:

What is Dimensional Modelling?

Tweet Share WhatsApp

Answer:

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.

Download Data Warehousing PDF Read All 131 Data Warehousing Questions
Previous QuestionNext Question
What are the difference between Snow flake and Star Schema? What are situations where Snow flake Schema is better than Star Schema to use and when the opposite is true?What is Log Switch?