A degenerate dimension is a dimension that is
stored in a fact table or data that is dimensional in nature but stored in a
fact table. There may be more than one degenerate dimension inside a fact table.
Ex:
dimension attributes such as invoice number,order
number,invoice id present in fact table can all be classified as degenerate dimensions.
No comments:
Post a Comment