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 |
Explain what are necessary tasks to install reportnet software?
Explain swot analysis?
What is hash partition?
Where the data cube technology is used?
What are the main steps to build the data warehouse?
Name a few sectors which use data warehousing?
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.
Can you brief about the Data warehouse project you worked on?
Explain what is fact less fact table? Where you have used it in your project?
what is data validation strategies for data mart validation after loading process
What are the types of dimensional modeling?
Explain why fact table is in normal form?