Jayashree

 Profile Answers by Jayashree 

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

Jyothsna

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

ashok

• 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

ex

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

but

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

Guest

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

mamathareddy

• 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

Rajkumar

• 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

valid.

Stephen

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