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
Is there any difference in testing database and data ware housing?
Code the tables statement to produce a multi-level frequency?
Suppose we want to display zero when null values coming to report how can we do that?
Explain how are the dimension tables designed?
What are fact, dimension, and measure?
What are the differences between datamart vs. Reporting cube?
What are vaious etl tools in the market?
What is surrogate key? Where we use it?
What are various warehousing tools?
Explain about core dimension, balanced dimension, and dirty dimension?
Explain meta data?
Explain why should you put your data warehouse on a different system than your oltp system?
How to add a number to a macro variable?
In document how to create metrics?
What is aggregate fact table?
