When should one use an MD-database (multi-dimensional
database) and not a relational one?
Answer Posted / 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 |
Post New Answer View All Answers
What are the different types of data warehousing?
Difference between cold fusion 5 and cold fusion mx 6?
Explain what are fact, dimension, and measure?
What are universe requirements?
What is the function of etl when used in data warehousing?
How do you create surrogate key using ab initio?
Explain what are the methodologies of data warehousing?
How do we design a universe?
What are situations where snowflake schema is better than star schema when the opposite is true?
Explain what are the advantages data mining over traditional approaches?
How to get the first 100 rows from the flat file into the target?
What is meant by metadata in context of a data warehouse?
What are the advantages of query studio compared to report studio?
What is the advantages data mining over traditional approaches?
What is an error log table in informatica occurs and how to maintain it in mapping?