What Is Junk Dimension? What Is The Difference Between Junk Dimension

1.	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 store. 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 store.

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 store.

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 store.

Discussion

No Comment Found

Related InterviewSolutions

Analysis In Business Objects?
Who Launches The Supervisor Product In Business Objects For First Time?
Multi Pass Sql:
Explain How To Mine An Olap Cube.
Differentiate Between Data Mining And Data Warehousing.
How Can You Access Your Repository With Different User Profiles?
What Is The Test Methodology For Testing Bo Universes?
When Is The Repository Created?
Can We Have Multiple Domains?
How Do You Restrict Access To Rows Of A Database?