Protocol
Reconcile what is missing and what should never have arrived
Everything expected can be present while the result is still wrong.
Before you use it
- Use when
- A source-to-target comparison reports no missing records, but the target may contain extras.
Keep this limit in mind
- A target may legitimately contain records outside this run. Define scope before treating all unmatched target rows as defects.
An idea to explore.
Try this idea.
Inspect the example, try the idea in your situation, then check your next move.
Why it matters
Compare the expected and actual populations in both directions. Expected minus actual reveals omissions; actual minus expected reveals unexpected additions. Use the same identity definition and cutoff in both comparisons, then inspect duplicates separately when repeated occurrences matter.
Steps
- Freeze the expected population and the matching target scope.
- Produce separate lists of missing and unexpected identities.
- Compare occurrence counts or duplicate-sensitive rows when identity membership alone is insufficient.
An example
All 80 intended partners arrived, but 12 unintended partners arrived too. A missing-only check would have declared success.
Check your result
The reconciliation reports omissions, extras and relevant multiplicity differences, not one reassuring percentage.
Save and practise this idea
My learning
Read. Recall. Repeat.
Save this idea and return to it on any device.
Keep exploring
Connected ideas
You are readingReconcile what is missing and what should never have arrived
Ideas that link here
These ideas link to this one. Check their conditions and limits before use.
Useful with this ideaName what one row means before joining two tables
Evidence and sources
EXCEPT returns rows in the first query but not the second, and removes duplicates unless ALL is specified.
A one-direction difference cannot also identify unexpected target rows; distinct-set comparisons can hide repeated occurrences.
Combining Queries: UNION, INTERSECT, EXCEPT · Section 7.4
All sources (1)
Edition and review
Version 0.1.0
No review details are supplied for this edition.