How it works

Reconciliation checks for differences between two data sets. This will assist with data stewardship as you can easily compare data sets in the one place to check for completeness.

You can compare two data sets in the one results table to see mismatches, which will highlight the field that does not match in both data sets, and orphan records, which occur when a record exists in only one of the two data sets.

You will need to provide a source and target data base and a query for both your source and comparison data set. Once you’ve run the reconciliation rule, Loome will create a results grid with both data sets that also highlights the differences for each mismatched row. You can also see which data set has records that aren’t included in the other data set. Once the issues for these records have been resolved, they will be marked as a match in the results grid the next time this reconciliation rule is run.

In the following example, Loome will check for discrepancies between two transaction history data sets.

A gif showing how to create a Reconciliation Rule in Loome Monitor.