Interested to Buy Any Domain ? << Click Here >> for more details...
When should one use an MD-database (multi-dimensional
database) and not a relational one?
- 2 Answers
- 9035 Views
- IBM, I also Faced
- E-Mail Answers
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 the difference between dependent data warehouse and independent data warehouse?
What is surrogate key? Where we use it?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
Explain er diagram?
What is execution plan?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
What is recovering sessions?
for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?
What does level of granularity of a fact table signify?
how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause
Describe the differences between a data warehouse and data mart.
What are algorithms provided by Microsoft in SQL Server?
What is meta data and system catalog?
What are parallel querys and query hints?
