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
What is perform recovery?
What a static and local variable?
What is a source qualifier?
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
What is ods (operation data source)?
Explain meta data?
Explain the difference between keylokup and joiner?
What are non-additive facts in detail?
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
What is MODEL is Data mining world?
What are the other names given to data warehousing?
Explain what are the different methods of loading dimension tables?
What is recovering sessions?
List down some of the real time data-warehousing tools?
Explain the main difference between inmon and kimball philosophies of data warehousing?