Matching Specification

Two-source matching specifications are located in the Matching subsection of the Specifications section in the navigation tree. To create a two-source matching specification:

• Right click on the Matching subsection of the Specifications section of the navigation tree and select Create match specification.

• In the pop up window enter a match specification name, select the Match two source type, and select a data source which contains data you want to match.

Matching specification consists of:

• Data table - name of the input table that contains records you want to match onto the reference table. It will be updated with the result of the matching. Columns that will be updated are listed below.

• Reference table - name of the table that contains records to which you want to match records from the data table.

• One or more match rules that specify how to find matches.

• Manual Matching - names of tables that are created by the system to store the results of manual editing. When you create a new match specification the table names are generated automatically.

• Stewarship - configuration of the Steward UI to review and modify the matches manually.

It is a requirment that the match table must have the following column:

• data_id nvarchar(900) - must be a primary key: unique identifier that cannot be null

At the beginning of matching specification execution, InfoLink will check whether the data table has the following columns. The missing columns will be added to the match table:

• ref_data_id nvarchar(900) - The result of matching will be stored in this column: it is a refence to the data_id column of the reference table.

• match_weight - the weight of the match from 0 to 100.

• match_run_name contains the name of matching run that produced the match.