Records Missing After a Sync: How to Find the Gap
A source-to-target comparison makes missing records explicit by matching the identifiers that should exist on both sides.
Start with the expected source records
The source defines the records that should be represented in the destination for the comparison scope.
Match by a stable identifier
Use a shared business key such as an order ID, customer ID, invoice number, or external reference.
Investigate the exceptions
Instead of manually comparing two complete datasets, reconciliation narrows the investigation to the missing records.
Frequently asked questions
How do I detect missing records after a sync?
Compare source and target records using a stable identifier and surface source IDs without a matching target ID.
Do not stop at integration success.
Compare the actual source and target data after the workflow finishes.
Start verifying→