A DEGENERATE dimension?is a?Dimension which has only a single attribute.

This dimension is typically represented as a single field in a fact table.

The data items thar are not facts and data items that do not fit into the existing dimensions are

termed as Degenerate Dimensions.
Degenerate Dimensions are the fastest WAY to group similar transactions.
Degenerate Dimensions are USED when fact TABLES represent transactional data.
They can be used as primary KEY for the fact table but they cannot act as foreign keys.

A Degenerate dimension?is a?Dimension which has only a single attribute.

This dimension is typically represented as a single field in a fact table.

The data items thar are not facts and data items that do not fit into the existing dimensions are

termed as Degenerate Dimensions.
Degenerate Dimensions are the fastest way to group similar transactions.
Degenerate Dimensions are used when fact tables represent transactional data.
They can be used as primary key for the fact table but they cannot act as foreign keys.