What is dimensional modelling?

1.	What is dimensional modelling?
Answer» Dimensional Modeling is a technique of data structuring performed for optimizing the data storage and FASTER data retrieval in the data warehouse. It consists of 2 types of TABLES - FACT tables and dimension tables. The fact tables are used for storing different transactional data along with the foreign keys from the dimension tables qualifying the data. The purpose of Dimensional modelling is to achieve faster data retrieval and not the HIGHEST degree of normalization.

Answer»

Dimensional Modeling is a technique of data structuring performed for optimizing the data storage and FASTER data retrieval in the data warehouse. It consists of 2 types of TABLES - FACT tables and dimension tables. The fact tables are used for storing different transactional data along with the foreign keys from the dimension tables qualifying the data.

The purpose of Dimensional modelling is to achieve faster data retrieval and not the HIGHEST degree of normalization.

Discussion

No Comment Found

Related InterviewSolutions

What are some of the common mistakes encountered in data modelling?
What is the importance of the third normal form?
How can you perform reverse engineering in data modelling?
What are the types of dimensions in data modelling?
What is dimensional modelling?
What Are Recursive Relationships?
How can you relate CAP Theorem to database design?
What are the types of visual data modelling techniques?
What are the critical relationship types in a Data Model?
Explain snowflake schema database design.

What is dimensional modelling?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment