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
How to create context?
What are the difference between snow flake and star schema?
what are relationships?
Explain what are the advantages and disadvantages of reporting directly against the database?
What is the limit to the number of sources and targets you can have in a mapping?
How can you implement many relations in star schema model?
What is the function of etl when used in data warehousing?
Explain what is full load & incremental or refresh load?
Explain why are oltp database designs not generally a good idea for a data warehouse?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
What are the stages of datawarehousing?
What is the difference between constraind base load ordering and target load plan?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
What are the various methods of getting incremental records or delta records from the source systems?
What are modeling tools available in the market?
