Explain dimensional modelling?



Explain dimensional modelling?..

Answer / Purushottam Das

Dimensional modeling is a method for organizing data within a data warehouse to support efficient querying and reporting. The model consists of fact tables, which contain numeric measures or facts, and dimension tables, which provide contextual information about the data. Dimensional modeling enables easy navigation through large amounts of data, as users can drill down from high-level summaries to detailed transactional data.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Warehouse General Interview Questions

What is the difference between narmal load and bulk load?

1 Answers  


if you use oracle sql*loader , how do you transform data with it during loading?

1 Answers  


what are different types of partitioning in oracle ?

3 Answers  


Explain dimensional modelling?

1 Answers  


Can any one explain the hierarchies level data warehousing.

1 Answers  


What is MODEL is Data mining world?

1 Answers   Bank Of America,


What is the difference between data warehouse and operational systems?

1 Answers  


Explain bus schema?

1 Answers  


What is data stream and data adaopter?

1 Answers  


what is the difference between MOLAP and ROLAP?

3 Answers  


What is batch processing?

1 Answers  


Explain what are the mapping paramaters and maping variables?

1 Answers  


Categories