When should one use an MD-database (multi-dimensional
database) and not a relational one?
Answers were Sorted based on User's Feedback
Answer / shribhagwan
1 Because More than one dimensions can be shareble for Other
Department
2 The Physical Load will be less.
3 Less Complexity of Fact
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
What are necessary tasks to install reportnet software?
Explain the difference between oltp and olap?
What are modeling tools available in the market?
waht is the advantage of infoset query
What is up date strategy and what are th options for update strategy?
Define data warehouse?
What is the difference between view filter and report filter?
what is difference between drill & scope of analysis?
Where the cache files stored?
What is data validation strategies for data mart v?
How can you import tables from a database?
What are Non-additive facts?