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

Showing Answers 1 - 7 of 7 Answers

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.

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

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

  Was this answer useful?  Yes

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

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

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.

  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.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions