GeekInterview.com
Series: Subject: Topic:
Question: 67 of 133

Give examples of degenerated dimensions

Asked by: Interview Candidate | Asked on: Jul 17th, 2006
Showing Answers 1 - 4 of 4 Answers
Bie Tie

Answered On : 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.   

Yes  1 User has rated as useful.
  
Login to rate this answer.
siokbietie

Answered On : Aug 14th, 2006

View all answers by siokbietie

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.

  
Login to rate this answer.
mri_sonam

Answered On : Dec 18th, 2008

View all answers by mri_sonam

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.

  
Login to rate this answer.
mahesh

Answered On : 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

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.