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 index awareness in universe?
Why should you put your data warehouse on a different system than your oltp system?
What are the advantages of raid 1, 1/0, and
What is the main difference between inmon and kimball philosophies of data warehousing?
What are Aggregate tables?
What is metadata in context of a datawarehouse?
Explain what is type 2 version dimension?
What is pre-emptive and non-pre-emptive?
What is the difference between static cache and dynamic cache?
In document how to create metrics?
Where we use surrogate key explain with example?
What is data stream and data adaopter. Is it same are different? Explain?
What are data modeling and data mining?
How do you setup Lo-cockpit?
Explain the main difference between inmon and kimball philosophies of data warehousing?