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 "method/1"?
How many types of facts and what are they?
What is the use of tabular model, tabular sql, tabular reference in real time application?
for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?
Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?
Why we use repository connectivity?
What is a linked cube?
How to drill through from a powerplay cube to reportnet?
What is a hash cluster?
The same tier?
What are situations where snowflake schema is better than star schema when the opposite is true?
What is surrogate key? Where we use it? Explain with examples.
Explain where do we use semi and non additive facts?
Why denormalization is promoted in universe designing?
explain about dirty dimension?
