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
What is the main difference between schema in rdbms and schemas in datawarehouse?
What is vdl (view definition language) explain?
What is a Decision Tree Algorithm?
What is execution plan?
Explain what is the difference between view filter and report filter?
How are models actually derived?
What is metadata in context of a datawarehouse?
What are the types of SCD?
What is the definition of cube in datawarehousing?
What is data warehouse architecture?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
What is a cube in data warehousing concept?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
Explain what are the different methods of loading dimension tables?