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

User login

Navigation

Today in Finance

Reality Check for Young Finance Pros
Shielding Yourself Against Fraud
Class-action Values Plunging, but Not for Long
Sympathy for Fair Value Critics
Retail Hits: Writedown in Aisle Three

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

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

Average:

Your rating: None

Submitted by Prasenjit on Tue, 08/19/2008 - 05:44