prasad Nallapati

• Oct 17th, 2005

 

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. A good example would be a trade fact in a company that brokers equity trades.

ravi kumar guturi

• Mar 10th, 2006

 

A junk dimension is a used for constrain queary purpose based on text and flag values.

Some times a few dimensions discarded in a major dimensions , That time we kept in to one place the all discarded dimensions that is called junk dimensions.

vivek1708

 Profile Answers by vivek1708 

• Jul 30th, 2008

 

Junk dimensions are particularly useful in Snowflake schema and one of the reasons why snowfalke is preferred over the star schema.

There are dimensions that are frequently updated. So from the base set of the dimensions that are already existing, we pull out the dimensions that are frequently updated and put them into a separate table.
This dimension table is called the junk dimension.