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 the steps to build the datawarehouse?
What is a Data Cube?
Explain multivalued dependency?
Why facts table is useful in representing the data?
Explain what are the various methods of getting incremental records or delta records from the source systems?
How do you setup Lo-cockpit?
Where do we use semi and non additive facts?
hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit
Define Data Warehousing?
What is surrogate key? Where we use it? Explain with examples.
How to performance tune reports?
What are the methodologies of data warehousing?