When should one use an MD-database (multi-dimensional
database) and not a relational one?
- 2 Answers
- 8226 Views
- IBM, I also Faced
- E-Mail Answers
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 is the difference between constraind base load ordering and target load plan?
What are necessary tasks to install reportnet software?
What are Fact tables and Dimension Tables?
Do you view contain data?
What is the difference between ods and oltp?
What is a cube in data warehousing concept?
Explain some of modeling tools available in the market?
Explain Process flow in data warehouse??
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
Give some difference between oltp and olap.
What is crass reference table?
Explain what are slowly changing dimensions?
Teradata 
