Output Columns

In addition to the input columns, the following columns are added while generating the output of a Transactional Match job:
Parameter Description Output Value
Match Record Type Identifies the type of match record in a collection. The possible values are S (suspect record), D (duplicate record) and U (unique record).
Match Score Identifies the overall score between two records. The possible values range from 0 (zero) to 100 for duplicate and unique records, where 0 indicates a poor match and 100 indicates a very high-quality match.
Note: For suspect records, this value is 0.
Has Duplicates Indicates whether the suspect records has duplicates or not
For Suspect records, the possible output values are:
  • Y (if duplicates are present)
  • N (if duplicates are absent)

For Duplicate records, the output value is D.

For Unique records, the output value is U.