Transactional Match Report

Transactional Match matches suspect records against candidate records of a group of records to identify duplicates. The records are first grouped by a selected column, post which the first record is marked as the suspect record. All the remaining records of the group, termed as candidate records, are matched against the suspect record.

If the candidate record is a duplicate, it is assigned a collection number, the match record type is labeled a Duplicate, and the record is then written out. Any unmatched candidates in the group are assigned a collection number of 0, labeled as Unique and then written out as well.

Reporting

The Transactional Match job allows you to monitor the results of the job. The counters available are:

AVERAGE_SCORE: The average match score of all duplicates.
The possible values are 0-100, with 0 indicating a poor match and 100 indicating an exact match.
INPUT_SUSPECTS: The number of records in the input stream that the matcher tried to match to other records.
SUSPECTS_WITH_DUPLICATES: The number of input suspects that matched at least one candidate record.
UNIQUE_SUSPECTS: The number of input suspects that did not match any candidate records.
SUSPECTS_WITH_CANDIDATES: The number of input suspects that had at least one candidate record in its match group and therefore had at least one match attempt.
SUSPECTS_WITHOUT_CANDIDATES: The number of input suspects that had no candidate records in its match group and therefore had no match attempts.
TOTAL_DUPLICATES_SCORE: The total match score of all duplicates.
TOTAL_DUPLICATES: The total number of duplicates found.