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

Showing Answers 1 - 7 of 7 Answers


  • May 8th, 2006

A junk dimension is a collection of random transcational codes, flags and text attributes that are unrelated to any particular dimension.The junk dimension is simply a structure that provides the convienent place to store the junk dimension.

  Was this answer useful?  Yes


  • May 10th, 2006

A "junk" dimension is a collection of random transactional codes, flags and/or text attributes that are unrelated to any particular dimension. The junk dimension is simply a structure that provides a convenient place to store the junk attributes.where asA degenerate dimension is data that is dimensional in nature but stored in a fact table.

  Was this answer useful?  Yes


  • May 30th, 2006

junk dimension

the column which we are using rarely or not used, these columns are formed a dimension is called junk dimension

degenerative dimension

the column which we use in dimension are degenerative dimension


emp table has empno.ename,sal,job,deptno


we are talking only the column empno,ename from the emp table and forming a dimension this is called degenerative  dimension

  Was this answer useful?  Yes


  • Jul 13th, 2006

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


  • Sep 1st, 2006

hi ganesh

      i think junck dim is a  dimension combining all the small dim in to a big dim

      the main diff between junck and degenerate are junck dim have source but where as degenerated dim are not having any source

  Was this answer useful?  Yes


  • Sep 5th, 2006

A junk dimension is a convenient grouping of flags and indicators. It's helpful, but not absolutely

required, if there's a positive correlation among the values.


Their benefits:


Provide a recognizable, user-intuitive location for related codes, indicators and their

descriptors in a dimensional framework


Clean up a cluttered design that already has too many dimensions. There might be five

or more indicators that could be collapsed into a single 4-byte integer surrogate key in

the fact table


Provide a smaller, quicker point of entry for queries compared to performance from

constraining directly on these attributes in the fact table. If your database supports bit-

mapped indices, this potential benefit may be irrelevant, although the others are still


  Was this answer useful?  Yes


  • Apr 6th, 2007

Junk Dimension also called as garbage dimension.
A garbage dimension is a dimension that consists of low-cardinality columns such as codes, indicators, status,

and flags. The garbage dimension is also referred to as a junk dimension. Attributes in a garbage dimension are not

related to any hierarchy.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions