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
if you use oracle sql*loader , how do you transform data with it during loading?
Explain me what is vldb?
Explain what are the different types of data warehousing?
What is surrogate key? Explain with examples.
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
What are components of report studio?
How to design file watch jobs?
What are the methodologies of data warehousing?
What is your spectra photometer working principles?
How can we run the graph?
How to define a cube??
What is data stream and data adaopter?
What are the different methods of loading dimension tables?
What is metadata in context of a datawarehouse?
Who needs data warehousing?