Talend Connect
Virtual Summit
JOIN US!
And visit the Customer
& Community Lounge.
May 27-28, wherever you are.

Generation of MD5 Hash key in table

Highlighted
Six Stars

Generation of MD5 Hash key in table

Hi,

I have a requirement, where I need to move data from source table to target table.

here i don't want to move all data to target table, I want to move only updated rows, so instead of checking all columns  i want to generate Hash-key in the target table. 

I downloaded MD5 function from talend exchange. 

Can you please help me how to use this function with respect to table because all I can see is it is used to generate Hash-key for file.

Can't we use it for table? If yes, please help me with the steps.

Thanks in advance

 

Regards

ShaX

Tags (1)

Accepted Solutions
Highlighted
Moderator

Re: Generation of MD5 Hash key in table

@ShaX ,i can suggest to use tAddCRCrow to generate a for the all column through talend and do the inner join and take the inner join rejects and populate to target.

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

View solution in original post

Highlighted
Moderator

Re: Generation of MD5 Hash key in table

@ShaX ,your job should be below way.

Untitled.png

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

View solution in original post


All Replies
Highlighted
Employee

Re: Generation of MD5 Hash key in table

Hi,

 

   If you are using any custom component, I would suggest to get in touch with the corresponding developer as she/he will be the authority for that custom component.

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved :-)

Highlighted
Employee

Re: Generation of MD5 Hash key in table

Hi,

 

    At the same time, if you want to segregate the records as insert and update records, you can do it in Talend by joining the input table and the target table as lookup using inner join. All the records which pass the inner join will be update records and any record which is not having match will be insert record.

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved :-)

Highlighted
Moderator

Re: Generation of MD5 Hash key in table

@ShaX ,i can suggest to use tAddCRCrow to generate a for the all column through talend and do the inner join and take the inner join rejects and populate to target.

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

View solution in original post

Highlighted
Moderator

Re: Generation of MD5 Hash key in table

@ShaX ,your job should be below way.

Untitled.png

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

View solution in original post

Highlighted
Six Stars

Re: Generation of MD5 Hash key in table

@manodwhb  Thanks for ur reply.

This solved my problem to some extent.

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog

Downloads and Trials

Test drive Talend's enterprise products.

Downloads