Sivarao

• Aug 16th, 2005

 

the values of dimension which is stored in fact table is called degenerate dimensions. these dimensions doesn,t have its own dimensions.

jaladi_sanju

 Profile Answers by jaladi_sanju 

• Dec 22nd, 2005

 

A attribute in fact table it?s not a fact and it?s not a key value

Balaji

• Jan 6th, 2006

 

in simple terms, the column in a fact table that does not map to any dimensions, neither it s a measure column.

for e.g Invoice_no, Invoice_line_no in fact table will be a degenerate dimension (columns), provided if you dont have a dimension called invoice.

senthil kumar B

• Feb 13th, 2006

 

Degenerate Dimensions : If a table contains the values, which r neither dimesion nor measures is called degenerate dimensions.Ex : invoice id,empno