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
- 8780 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 |
Explain can a dimension table contains numeric values?
Explain what are the various methods of getting incremental records or delta records from the source systems?
What is ods (operation data source)?
What are the stages that are required in data warehousing?
What is critical column?
Can you state some of the innovations throughout history?
How to test report in reportnet?
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
What needs to be done when the database is shutdown?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
Explain the main difference between inmon and kimball philosophies of data warehousing?
Explain what is analytical or analytic mean?
Teradata 
