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 is MDX?
Explain the difference between data ware house & data mart?
What is the difference between aggregate table and materialized view?
I know of using applysimple, but there are other ways too?
What is data stream and data adaopter. Is it same are different? Explain?
Explain about Control M JObs detaily?How to execute this.
2 Answers Scope International,
Explain dimension table ?
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
What are the differences between star and snowflake schema?
Explain what is the difference between datawarehouse and bi?
what is the difference between MOLAP and ROLAP?