Data Warehousing Question:
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
Answer:
Junk dimension: Grouping of Random flags and text attributes in a dimension and moving them to a separate sub dimension. Degenerate Dimension: Keeping the control information on Fact table ex: Consider a Dimension table with fields like order number and order line number and have 1:1 relationship with Fact table, In this case this dimension is removed and the order information will be directly stored in a Fact table in order eliminate unnecessary joins while retrieving order information.
| Previous Question | Next Question |
| Why fact table is in normal form? | What is the main difference between Inmon and Kimball philosophies of data warehousing? |