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 many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
How to pivot data using informatica when you have variable amount of pivot rows?
What are the steps to build the datawarehouse?
Explain the main differences between star and snowflake schema?
Compare cold fusion with other programming languages?
What are the steps involved in designing a fact table?
What are non-additive facts in detail?
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
What are the design methods of data warehousing?
How can you implement many relations in star schema model?
What are loops in Datawarehousing?
Explain a relation schema and a relation?
How to generate the cubes in framework manager?
Explain what are the various file formats involved in reportnet?
Why denormalization is promoted in universe designing?
