Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / arasu
example for junk dimension:
consider a trade company which consists of fact about trading that take places in a share trading firm.in these there may be some facts like mode of trade(which indicates whether the user is trading through phone or online)which will be not related to any of the dimensions such as account,date,indices,amount of share etc.
so these unrelated facts are removed from the fact table and stored as a separate dimension as a junk dimension which will be useful to provide extra information
| Is This Answer Correct ? | 30 Yes | 1 No |
Post New Answer View All Answers
Explain the importance of data warehouse?
What is scd1 , scd2 , scd3?
How can you import tables from a database?
Explain what are non-additive facts?
What is a staging area? Do we need it? What is the purpose of a staging area?
How to generate the cubes in framework manager?
What is a functional dependency f said to be minimal?
Explain what are the different methods of loading dimension tables?
What is partitioning? What are the types of partitioning?
Explain why are oltp database designs not generally a good idea for a data warehouse?
Explain how are the dimension tables designed?
Explain Association algorithm in Data mining?
Explain the difference between data ware house & data mart?
Explain what are the modules in power mart?
Explain why should you put your data warehouse on a different system than your oltp system?
