72. Why might joining two apparently correct business tables inflate the reported totals?
EasyProblem structuring
Technical
Show model answer
A key may repeat in both tables, creating several matched rows for one underlying item. Summing after that join can multiply an amount even though each original table was accurate.
Check the intended record relationships, key uniqueness, unmatched items, and totals before and after the transformation. Do not repair the result by deleting rows arbitrarily or assuming a successful join operation proves the business reconciliation is correct.
What interviewers listen for
- Check intended relationships and key uniqueness
- Reconcile counts and totals across the join
- Avoid arbitrary deletion to force a desired result