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 |
How to performance tune reports?
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
What is the use of tabular model, tabular sql, tabular reference in real time application?
What is VLDB?
What is latest version of power center / power mart?
Explain swot analysis?
What is fact less fact table? Where you have used it in your project?
Explain the data types present in bo n wht happens if we implement view in the designer n report?
What are modeling tools available in the market?
What are Aggregate tables?
explain about balanced dimension,
What are the data marts?