When should one use an MD-database (multi-dimensional
database) and not a relational one?
Answer Posted / 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 |
Post New Answer View All Answers
How can you import tables from a database?
What are the different types of join operations?
How to create prompts in report net?
What are the difference between snow flake and star schema?
Where do we use semi and non additive facts?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
What is the difference between agglomerative and divisive hierarchical clustering?
What is difference between model & package?
What are the advantages and disadvantages of reporting directly against the database?
Explain what is the difference between olap and datawarehosue?
What is data cleaning? How can we do that?
What are cluster analysis in data warehousing?
What are the reasons to use a chameleon method in data warehousing?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
How can we load the time dimension?