Setting up the Job - 6.5

Fuzzy matching

EnrichVersion
6.5
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
EnrichPlatform
Talend Studio
task
Data Governance > Third-party systems > Data Quality components > Matching components > Fuzzy matching components
Data Quality and Preparation > Third-party systems > Data Quality components > Matching components > Fuzzy matching components
Design and Development > Third-party systems > Data Quality components > Matching components > Fuzzy matching components

Procedure

  1. In the Repository tree view, expand Metadata and the FileExcel node where you have stored the main input schemas and then drop it onto the design workspace.

    A tFileInputExcel component holding your schema displays on the workspace.

  2. Do the same with the reference input schema to display the reference tFileInputExcel on the workspace.
  3. Drop a tBlockedFuzzyJoin and tLogRow (x3) from the Palette onto the design workspace.
  4. Connect the main and reference input Excel files to tBlockedFuzzyJoin using Main links. The link between the reference input Excel file and tBlockedFuzzyJoin displays as a Lookup link on the design workspace.
  5. Connect tBlockedFuzzyJoin to the three tLogrow components using the Matches, Possible Matches and Non Matches links.