Friday, December 7, 2012

Degenerate Dimension

What is a Degenerate Dimension ?

 A degenerate dimension is a dimension which is stored in a fact table.

Ex:

Consider SH schema and a new dimension Sale_id in the Sales Fact table is inserted then Sale_id is known as Degenerate Dimension


Posted by
Labels: , ,

1 comment:

  1. AnonymousMarch 24, 2015 at 11:38 PM

    "A degenerated dimension is dimension which is present in fact table and it doesn't present in any other dimension tables"

    ReplyDelete

Subscribe to: Post Comments (Atom)
Related Posts Plugin for WordPress, Blogger...