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
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
What is data analytics in simple terms?
What is the difference between power center & power mart?
How can we determine what records to extract?
Explain what are non-additive facts?
what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc
Explain how are the dimension tables designed?
What are the steps of implementing data warehousing?
What is edw?
What are situations where snowflake schema is better than star schema when the opposite is true?
What is incremintal loading?
What is difference macros and prompts?
What are the various file formats involved in reportnet?
What are the different types of data warehousing?
Where the data cube technology is used?
