Protocol

Reconcile what is missing and what should never have arrived

Everything expected can be present while the result is still wrong.

About 1 min read

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.

Keep reading

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

  1. Freeze the expected population and the matching target scope.
  2. Produce separate lists of missing and unexpected identities.
  3. 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.

Use email
Keep exploring

Connected ideas

You are readingReconcile what is missing and what should never have arrived

Evidence and sources
Supports

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.

Read this idea as JSON · Release details