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 is difference between query studio and report studio?
Compare cold fusion with other programming languages?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What are the difference between snow flake and star schema?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
I know of using applysimple, but there are other ways too?
Explain what are the various transformation available?
What are the advantages of raid 1, 1/0, and
What are fundamental stages of data warehousing?
What is difference macros and prompts?
What is a relationship?
Explain the definition of normalized and denormalized view?
What is meant by metadata in context of a data warehouse and how it is important?
What is analytical or analytic mean?
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.