Executing the Job - 6.5

Synonym index

author
Talend Documentation Team
EnrichVersion
6.5
EnrichProdName
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
task
Data Governance > Third-party systems > Data Quality components > Standardization components > Synonym index components
Data Quality and Preparation > Third-party systems > Data Quality components > Standardization components > Synonym index components
Design and Development > Third-party systems > Data Quality components > Standardization components > Synonym index components
EnrichPlatform
Talend Studio
  1. Press F6 to run this Job.

    The execution result reads as follows in the console of the Run view.

    From this result, if you take the input data Chris Toom for example, you can see that:

  • this record is recognized as group 2 with a group size equal to 3. This means that 3 pairs of exact match reference entries are found from the two synonym indexes in use. The exact match for the first name are Christian, Christiaan and Christoffel, and the exact match for the last name are toomx3.

  • the SCORES column contains two sub-columns.

    These sub-columns present the matching scores in regards to the matched_fname and to the matched_lname reference columns respectively. Each figure listed in the SCORE column is equal to the sum of the two figures of the same row in the sub-columns of the SCORES column.