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
Explain about core dimension, balanced dimension, and dirty dimension?
Why is business intelligence (bi) important in data warehousing?
What is the extension of file to save template?
What needs to be done while starting the database?
What is the goal of optimizer?
Compare and contrast aggregates & indexes
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
Start a batches with in a batch?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
What is the difference between data warehouse and operational systems?
What are situations where snowflake schema is better than star schema when the opposite is true?
Can we take backup when the database is opened?
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
What is called data cleaning?
Explain what are the modules in power mart?