Data Warehousing Question:

What is dimension modeling?

Data Warehousing Interview Question
Data Warehousing Interview Question

Answer:

A logical design technique that seeks to present the data in a standard, intuitive framework that allows for high-performance access. There are different data modeling concepts like ER Modeling (Entity Relationship modeling), DM (Dimensional modeling), Hierarchal Modeling, Network modeling. However, popular are ER and DM only.


Previous QuestionNext Question
What is data cleaning? How can we do that?Where the cache files stored?