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
- 8800 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 |
After the complete generation of a report who will test the report and who will analyze it?
Briefly state different between data ware house & data mart?
What is Discover and Execute in XMLA?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
Explain vldb?
What is type 2 version dimension?
DWH architecture?
What is data stream and data adaopter. Is it same are different? Explain?
Advantages of de normalized data?
What is Star Schema?
What are the stages of datawarehousing?
Explain dimension table ?
Teradata 
