thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Advanced

Degenerate Dimension

A dimension key, such as an order or invoice number, stored in the fact table with no separate dimension table.

Definition

Degenerate dimensions are identifiers with no other attributes. They are useful for grouping line items into their parent transaction.

Example

InvoiceNumber stored directly in FactSalesLine.

Exam tip

A transaction ID in the fact table with no corresponding dimension = degenerate dimension.

Related terms