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
What is bi?
What are the types of partitioning?
What are the methodologies of data warehousing?
what are the all possible features supported modify stage?
explain about balanced dimension,
Briefly state different between data ware house & data mart?
Explain why denormalization is promoted in universe designing?
What is critical column?
Store (and count) non-fact records?
Explain piconet?
Explain what are the methodologies of data warehousing?
After the complete generation of a report who will test the report and who will analyze it?
What are snapshots? What are materialized views & where do we use them?
What are algorithms provided by Microsoft in SQL Server?
what are the other factors of the database on which the loading performance depend?
