Generation of MD5 Hash key in table

[Anonymous]

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

[Anonymous]

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 🙂

[Anonymous]

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 🙂

[manodwhb · Accepted solution]

@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.

[manodwhb]

@ShaX ,your job should be below way.

[Anonymous]

@manodwhb  Thanks for ur reply.

This solved my problem to some extent.