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

Factless Fact Table

A fact table with dimension keys but no numeric measures, recording that an event or coverage relationship occurred.

Definition

Factless fact tables track events such as student attendance, or coverage such as which products were on promotion, so analysts can count occurrences or find what did not happen.

Example

FactAttendance(DateKey, StudentKey, ClassKey)

Exam tip

To answer 'which promoted products did not sell', you need a coverage factless fact table.

Related terms