77. Why can joining today's customer status to last year's transactions mislead a historical report?
HardData & validation
Technical
Show model answer
Current status can differ from the status that applied when the transaction occurred. Using today's value may rewrite history, producing a plausible total that does not answer the time-specific question the stakeholder intended to investigate or compare across reporting periods.
I'd confirm current versus historical intent and find suitable effective-dated evidence. One join rule cannot automatically answer every retrospective and current question without preserving the relevant temporal business meaning.
What interviewers listen for
- Define the temporal business question
- Use suitable effective-dated evidence
- Separate current from historical classification