trecordmatching not working

Four Stars

trecordmatching not working

Hi All,

 

    Im newbie to Talend. I need your help.

 

      Im comparing two columns (ID and NAME) from Source Table (Oracle table) against Refernce Table (ID and Name) from Oracle DB table. Im using trecordmatching component to do fuzzy match. The values in the refernce table are present in Source table but still the trecordmatching component returning output as None Match. Not sure why it not working I have pasted the job design and trecordmatching settings. 

 

Any help here is appreciated.

Employee

Re: trecordmatching not working

Hi,

 

   Could you please provide some sample data for both main and lookup flow for the analysis?

 

Warm Regards,

 

Nikhil Thampi


Warm Regards,
Nikhil Thampi
Please appreciate our members by giving Kudos for spending their time for your query. If your query is answered, please mark the topic as resolved :-)
Four Stars

Re: trecordmatching not working

Hi,

 

  Attached Sample Data

Employee

Re: trecordmatching not working

Hi Manoj,

 

      I have created a sample job by reading your sample data and the data was coming properly to exact and possible matches. 

 

image.png

 

The output data is as shown below.

 

image.png

image.png

 

I am also attaching the job which I created from my end and the sample data in excel sheet for your reference. 

 

If the details provided has helped you to clear your query, could you please mark the topic as solution accepted.

 

Warm Regards,

 

Nikhil Thampi


Warm Regards,
Nikhil Thampi
Please appreciate our members by giving Kudos for spending their time for your query. If your query is answered, please mark the topic as resolved :-)

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch