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 · Intermediate

Transaction Fact Table

A fact table with one row per discrete event at the most atomic grain, such as each sale or each click.

Definition

Transaction fact tables are the most common type. They are sparse, because rows exist only when events occur, and they support the most flexible analysis.

Exam tip

One row per event = transaction fact table.

Related terms