Basics - What is degenerate dimension table?

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Go To First | Previous Question | Next Question

Basics | Question 43 of 113

What is degenerate dimension table?

Total Answers and Comments: 4

Last Update: February 13, 2006

Sponsored Links

Best Rated Answer

—

Submitted by: Balaji

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.

Above answer was rated as good by the following members:
biju_cognos, cfo_2016

August 16, 2005 01:13:29

Sivarao

RE: What is degenerate dimension table?

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

Is this answer useful? Yes | No

December 22, 2005 05:30:09

jaladi_sanju

Member Since: October 2005 Contribution: 1

RE: What is degenerate dimension table?

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

Is this answer useful? Yes | No

January 06, 2006 16:09:11

Balaji

RE: What is degenerate dimension table?

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.

Is this answer useful? Yes | No

2 0

Overall Rating: +2

February 13, 2006 03:32:35

senthil kumar B

RE: What is degenerate dimension table?

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

Is this answer useful? Yes | No

User Name		Remember Me?
Password

Question Bank