What is junk dimension? What is the difference between junk dimension and degenerated dimension?
- 1 Answers
- 1156 Views
- I also Faced
- E-Mail Answers
Answer / Pappu Chauhan
Junk Dimension refers to a data warehouse dimension that does not have any meaningful relationships with the fact table or other dimensions. It is used to store large amounts of data that cannot be normalized due to their nature (e.g., free-form text, binary data). A Degenerated Dimension, on the other hand, has a one-to-many relationship with the fact table and can be eliminated by denormalization to improve query performance. The main difference is that Junk Dimensions are typically used for non-normalized data, while Degenerated Dimensions are used when the relationship between the dimension and the fact table is not meaningful.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is normalization, first normal form, second normal form, third normal form?
Why fact table is in a normal form?
Can any one explain about core dimension, balanced dimension, and dirty dimension?
What is static and local variable?
What is core dimension?
What is the function of surrogate key in data warehousing?
Explain the definition of normalized and denormalized view and what are the differences between them?
what are the others of "bad files" and "discard files" when using sql*loader?
three ways sql*loader could load data, what are those three types?
what is a hot file, why we need in datawarehousing, where we used in general
What is the very basic difference between data warehouse and operational databases?
What is the difference between constraind base load ordering and target load plan?
Teradata 
