What is called dimensional modelling?



What is called dimensional modelling?..

Answer / Abhinav Kumar Tripathi

Dimensional modeling is a process used in data warehousing to structure data into a multi-dimensional schema, which makes it easy to analyze and query the data. It involves organizing data into fact tables and dimension tables, with the fact table containing measurable values (facts) and the dimension tables providing contextual information (like time, geography, product categories).

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Warehouse General Interview Questions

What is Snow Flake Schema design in database?

3 Answers  


What according to you might be the future of data warehousing?

1 Answers  


What is surrogate key? Where we use it explain with example?

1 Answers  


What is operational data source (ODS)?

2 Answers  


What are session timeout and application timeout? Where we have to do this process?

1 Answers  


Tell me what is degree of a relation?

1 Answers  


What are CUBES?

2 Answers  


What is prompt types of prompts?use of prompts syntax of prompt?

1 Answers  


What is data validation strategies for data mart v?

1 Answers  


How do you setup Lo-cockpit?

1 Answers  


Explain the difference between keylokup and joiner?

1 Answers  


What is a fact, dimension, measure?

1 Answers  


Categories