Setting up the Job - Cloud - 8.0

Data matching with Talend tools

Version
Cloud
8.0
Language
English
Product
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Data Quality components > Matching components > Continuous matching components
Data Governance > Third-party systems > Data Quality components > Matching components > Data matching components
Data Governance > Third-party systems > Data Quality components > Matching components > Fuzzy matching components
Data Governance > Third-party systems > Data Quality components > Matching components > Matching with machine learning components
Data Quality and Preparation > Third-party systems > Data Quality components > Matching components > Continuous matching components
Data Quality and Preparation > Third-party systems > Data Quality components > Matching components > Data matching components
Data Quality and Preparation > Third-party systems > Data Quality components > Matching components > Fuzzy matching components
Data Quality and Preparation > Third-party systems > Data Quality components > Matching components > Matching with machine learning components
Design and Development > Third-party systems > Data Quality components > Matching components > Continuous matching components
Design and Development > Third-party systems > Data Quality components > Matching components > Data matching components
Design and Development > Third-party systems > Data Quality components > Matching components > Fuzzy matching components
Design and Development > Third-party systems > Data Quality components > Matching components > Matching with machine learning components
Last publication date
2024-02-06

Procedure

  1. In the Repository tree view, expand Metadata - DB Connections where you have stored the main input schemas.
  2. Drop the relevant file onto the design workspace.
    The Components dialog box appears.
  3. Select tMysqlInput and click OK to drop the tMysqlInput component onto the workspace.
    The input table used in this scenario is called person. It holds several columns including the two columns name and email you want to do the fuzzy match on. The following capture shows the basic properties of the main input component:
  4. Do the same for the second input table you want to use as a reference, customer in this scenario.
    The following capture shows the basic properties of the reference input component:
  5. Drop the following components from the Palette onto the design workspace: tRecordMatching and three tLogRow.
  6. Connect the main and reference input components to tRecordMatching using Main links. The link between the reference input table and tRecordMatching displays as a Lookup link on the design workspace.
  7. Connect tRecordMatching to the three tLogRow components using the Matches, Possible Matches and Non Matches links.