jargon

Data engineering·Modelling for analysis

the table records that a student attended a class, with no numbers on it at all, and the only measure is counting rows.

Factless fact table

Also calledcoverage table, event registry

A fact table with keys and no numeric measures, recording that something happened or that a relationship was in force. It answers 'how many' and, more usefully, 'what did not happen' — the promotions with no sales, the students who did not attend — by comparing coverage against events. It confuses people because it looks empty, and it is one of the few clean ways to make an absence queryable.

Commonly confused with