topic Re: Hash in talend in Talend Studio

Hash in talend

MaheswarReddy — Thu, 24 Oct 2019 11:08:50 GMT

Hi Team,

I'm inserting data from one table to another table and i need to capture only change data on the next run.And the talend job should check all the columns , compare current table column data with the previous column data available in previous table column to column comparison should happen and all columns should be checked , even if there is insert/change in single column out of 20 columns, we should consider that as changed data and get the whole record into a new table.Please help me how to get only the modified data.

My DB is sql server

Thanks

Re: Hash in talend

Anonymous — Thu, 24 Oct 2019 14:41:51 GMT

Hi,

Did you check the CDC architecture available in Talend?

https://help.talend.com/reader/RLnX9FGglgivekyCIUAC3Q/AX_8eo1W6GwYpIOqnM4qAg

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

Re: Hash in talend

MaheswarReddy — Sun, 27 Oct 2019 21:09:43 GMT

Hi,

Thanks for your reply , but i'm using Talend open studio,

Please let me know any other idea.

Thanks,

Mahesh

Re: Hash in talend

Anonymous — Mon, 28 Oct 2019 13:43:44 GMT

Hi,

In that case I would recommend you to load the data to a stage table using Talend and then do the data comparison either with a tMap or using a tMSSQLServerRow component. If you are using Row component, then you will have to write SQL commands or stored procedure to do the data difference check.

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