Data Warehousing Basics Question:
Download Questions PDF

what is junk dimension?
what is the difference between junk dimension and degenerated dimension?


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 inorder eliminate unneccessary joins while retrieving order information..

Download Basics Data Warehouse Interview Questions And Answers PDF

Previous QuestionNext Question
Explain ER Diagram?Explain What are the different types of data warehousing?