sithu

 Profile Answers by sithu 

• Mar 24th, 2007

 

A Degenerate dimension is a Dimension which has only a single attribute.
This dimension is typically represented as a single field in a fact table.
Degenerate Dimensions are the fastest way to group similar transactions.
Degenerate Dimensions are used when fact tables represent transactional data.
They can be used as primary key for the fact table but they cannot act as foreign keys.
Cheers, Sithu
sithusithu@hotmail.com

Thiru

• Oct 4th, 2007

 

Degenerated dimension keys are keys in the fact table that are not dimension keys (Foreign keys to the Hiearchy/dimension tables) and measurements. Like, Order Number, Invoice Number etc.