What is degenerated dimention table?

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

Question Posted / ronni2216

7 Answers
10568 Views
Patni, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is degenerated dimention table?..

Answer / tamil

There few columns like, Invoice Number in Invoiceing Module
and Track number in Logistic modules and Vin Number in Car
manufacture module and some descriptions we can not
maintain in the dimensions since there could be huge number
of unique values. Insteade of mainitaing it in the
dimension, we would need to be place it in the associated
fact table for reporting purpose.

Is This Answer Correct ?

6 Yes

0 No

What is degenerated dimention table?..

Answer / seetharam

The dimension keys which are directly cming from the oltp
system with out any associated dimension to the fact table
.These are called degenerate dim or line item dimensions

Is This Answer Correct ?

1 Yes

0 No

What is degenerated dimention table?..

Answer / chinth

A degenerared dimension is a dimension which is having one
attribute,and is placed in a fact table.

for ex: invoice no

Is This Answer Correct ?

1 Yes

0 No

What is degenerated dimention table?..

Answer / pintu

IS it degenetrated dimension? Or,degenetrated dimension
table?

Is This Answer Correct ?

0 Yes

0 No

What is degenerated dimention table?..

Answer / uppala chary

The dimension which is not connected to any of the fact tble but key
exists in the fact table

Is This Answer Correct ?

0 Yes

0 No

What is degenerated dimention table?..

Answer / sujana

it is generated at runtime..acts as pk in fact table..

Is This Answer Correct ?

0 Yes

2 No

What is degenerated dimention table?..

Answer / ram

if dimensional table has repeat values

Is This Answer Correct ?

0 Yes

3 No

Post New Answer