Recall the three main fact table types and the question each one is best at answering.
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…
Sign up free — one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in