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
- 9040 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 |
if we increase the number of dimensions will the rows in fact table increase or decrease??
Can you brief about the Data warehouse project you worked on?
Explain why dimenstion tables are denormalized in nature?
what is difference between scd2 and scd3
Explain how many ways you create ports?
Difference between DSS & OLTP?
Explain the structure of cold fusion?
Explain grouped cross tab?
Can we start and stop single session in concurent bstch?
Describe the differences between a data warehouse and data mart.
What is normalization, first normal form, second normal form, third normal form?
what are different ways of loading data to data warehouse using oracle?
Teradata 
