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 can a dimension table contains numeric values?
Can any one explain the hierarchies level data warehousing.
Explain conformed fact?
Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar
What is Analysis Services?
What is drilling across?
How to create different types of templates?
How to pivot data using informatica when you have variable amount of pivot rows?
2.What is staging area ?
4 Answers HCL, IBM, iFlex, TCS,
Write a short note on data warehousing & three-Tier Warehouse architecture in detail.
What is many-to-many dimensional model in datawarehousing ?
What is application.cfm?