Bie Tie

• Aug 14th, 2006

 

Degenerated Dimension is a dimension key without corresponding dimension. Example:

     In the PointOfSale Transaction Fact table, we have:

         Date Key (FK), Product Key (FK), Store Key (FK), Promotion Key (FP), and POS Transaction Number  

Date Dimension corresponds to Date Key, Production Dimension corresponds to Production Key. In a traditional parent-child database, POS Transactional Number would be the key to the transaction header record that contains all the info valid for the transaction as a whole, such as the transaction date and store identifier. But in this dimensional model, we have already extracted this info into other dimension. Therefore, POS Transaction Number looks like a dimension key in the fact table but does not have the corresponding dimension table.

Therefore, POS Transaction Number is a degenerated dimension.

  

 

siokbietie

 Profile Answers by siokbietie 

• Aug 14th, 2006

 

Degenerated Dimension is a dimension key without corresponding dimension. Example:

     In the PointOfSale Transaction Fact table, we have:

         Date Key (FK), Product Key (FK), Store Key (FK), Promotion Key (FP), and POS Transaction Number  

Date Dimension corresponds to Date Key, Production Dimension corresponds to Production Key. In a traditional parent-child database, POS Transactional Number would be the key to the transaction header record that contains all the info valid for the transaction as a whole, such as the transaction date and store identifier. But in this dimensional model, we have already extracted this info into other dimension. Therefore, POS Transaction Number looks like a dimension key in the fact table but does not have the corresponding dimension table.

Therefore, POS Transaction Number is a degenerated dimension.

mri_sonam

 Profile Answers by mri_sonam 

• Dec 18th, 2008

 

Best example is "Invoice Number","bill number","PO Number", these all are degenerated dimensions in the Transaction Tables, they can be maintained in the fact table itself instead of  crating seperate dimensions for this.

mahesh

• Feb 2nd, 2013

 

A source table has a single column, we not transfer this column to dimension table, directly to connected to the fact table ,this fact table called the de-generated dimensional table

q

• Jun 20th, 2017

 

Order number, invoice number, POS Transaction number, bill number. These are all examples of degenerate dimension table

John Deacutis

• Dec 26th, 2017

 

POS Transaction, not POS Transaction NUMBER, is the degenerated dimension.