Skip to main content

Quick Reference: Fact Table Types at a Glance

Recall the three main fact table types and the question each one is best at answering.

data-modeling4 min read

Which fact table answers which time question? Start from the business time pattern If the time pattern is event, state, or lifecycle, the matching fact type usually follows. When is a transaction fact the strongest fit? When each row should represent one discrete business event at the moment it happened. Examples: one order line, one refund, one payment, one click. When is a periodic snapshot the strongest fit? When the business cares about regular-state comparisons at fixed intervals. Examples: month-end subscriber balances, daily inventory on hand, weekly open pipeline. When is an accumulating snapshot the strongest fit? When one process…

Read the full lesson

Sign up free: one personalized lesson every day, matched to your role and goals.

← Back to library

Contact us