Data Warehousing Basics Question:

Explain Dimensional Modelling?

Tweet Share WhatsApp

Answer:

Dimensional Modelling is a design concept used by many data warehouse desginers to build thier datawarehouse. 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 measuremnets ie, the dimensions on which the facts are calculated.

Dimensional Modelling is a design concept used by many data warehouse desginers to build thier datawarehouse. 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 measuremnets ie, the dimensions on which the facts are calculated.

Download Basics Data Warehouse PDF Read All 37 Basics Data Warehouse Questions
Previous QuestionNext Question
Explain What are the different types of data warehousing?Explain can a dimension table contains numeric values?