When should one use an MD-database (multi-dimensional
database) and not a relational one?
Answer Posted / abhishek upadhyay
The MD Database is used when there is a many to many
relationships in the dimensions.
For example : There are dimensions related to Customer key
and service location key.
Now one customer can shop in different service locations
and it may happen that one service location is beinbg used
by many customers to shop.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the advantages data mining over traditional approaches?
What are the different types of datawarehosuing?
Explain bus schema?
Tell me what is full load & incremental or refresh load?
How to drill through from a powerplay cube to reportnet?
Explain why should you put your data warehouse on a different system than your oltp system?
How do we design a universe?
Explain what is difference between query studio and report studio?
what is parallel query?
Explain about core dimension,
Explain what is the limit to the number of sources and targets you can have in a mapping?
List down some of the real time data-warehousing tools?
Explain which columns go to the fact table and which columns go the dimension table?
What are the methodologies of data warehousing?
Explain what are the various transformation available?