When should one use an MD-database (multi-dimensional
database) and not a relational one?

Answers were Sorted based on User's Feedback



When should one use an MD-database (multi-dimensional database) and not a relational one?..

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

When should one use an MD-database (multi-dimensional database) and not a relational one?..

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

Post New Answer

More Data Warehouse General Interview Questions

What are necessary tasks to install reportnet software?

0 Answers  


Explain the difference between oltp and olap?

0 Answers  


What are modeling tools available in the market?

0 Answers  


waht is the advantage of infoset query

0 Answers   iGate,


What is up date strategy and what are th options for update strategy?

2 Answers  






Define data warehouse?

0 Answers  


What is the difference between view filter and report filter?

0 Answers  


what is difference between drill & scope of analysis?

0 Answers  


Where the cache files stored?

0 Answers  


What is data validation strategies for data mart v?

0 Answers  


How can you import tables from a database?

0 Answers  


What are Non-additive facts?

0 Answers  


Categories