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.
Already have an account? Sign in