Something like an order number that describes the data but has the same grain as the fact table, so it lives in the fact table instead of a dimension table of its own; a Power Query table or a view can expose it.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Degenerate dimension in context, with comparison tables and the common traps.
Terms in this definition
- LIKE
Compares strings with a pattern that can contain the % and _ wildcards. Because it only understands character patterns, searching big volumes of text this way is much slower than using full-text search.
- Grain
What a single row in a fact table stands for at its most detailed level, defined by its dimension keys and attributes, such as one row for each order line on each day.
- Fact table
Stores the numbers captured when business events happen, like what each sale brought in; an analytical model rolls these up into measures and slices them by dimensions.
- Dimension table
Holds the entities, such as customer, product, store or date, by which facts are summarised in a snowflake or star schema. Users drill up and down through hierarchies of these dimensions.
- Event
Table in Log Analytics where entries from Windows event logs are kept.
- View
Shows a system through one chosen group of related concerns. No view is generic; each one is tied to whichever architecture it depicts.