Data Warehousing Basics Question: Download Questions PDF
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 inorder eliminate unneccessary joins while retrieving order information..
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 Question | Next Question |
Explain ER Diagram? | Explain What are the different types of data warehousing? |