Overview

Two-source matching automates the process of matching records in one table called data table onto records in another table called reference table. All matches are stored in the <data table name>_all_pairs table. The best match is selected by sorting all matches by weight in the descending order and the id of the best-matching reference record is stored in the ref_data_id column of the data table. To implement two-source matching you first create a matching specification of the two source match type in the Matching subsection of the Specifications section in the navigation tree. Then you can:

• execute it and see the result by right clicking on the specification name.

• or create the MatchTwoSource operation in a scenario that executes the specification.