Interested to Buy Any Domain ? << Click Here >> for more details...
When should one use an MD-database (multi-dimensional
database) and not a relational one?
- 2 Answers
- 8927 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 |
DWH architecture?
What is difference between e-r modeling and dimensional modeling?
Do you view contain data?
Explain what is analytical or analytic mean?
What is the difference between agglomerative and divisive hierarchical clustering?
What are necessary tasks to install reportnet software?
how to find unique records in informatica level
i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
What are the different methods of loading dimension tables?
What is ?Data mining??
Explain what are the various transformation available?
Teradata 
