topic Update in existing records in Talend Studio

Update in existing records

Anonymous — Wed, 17 Oct 2018 19:20:23 GMT

I have two database engines, both with the same structure of tables, I bring the records that have changes compared to my main database, what I need is to update only the records that have changes. I am trying to use tPostgresqlRow, but I have no way of keeping records, is there any other way to do it?

Re: Update in existing records

Anonymous — Thu, 18 Oct 2018 07:27:07 GMT

Hi,

Could you please try to use CDC concept in Talend to capture the modified records from source table and load them to target table? Please refer the help document link below for the details.

https://help.talend.com/reader/4UeRbZs9GU5n8b9nm3hUrQ/B0Q191MwaueG~7sM6O0~kg

If the answer has helped to resolve your query, could you please mark the topic as resolved? Kudos are also welcome 🙂

Warm regards,

Nikhil Thampi

Re: Update in existing records

Anonymous — Thu, 18 Oct 2018 17:06:56 GMT

Hello!
I already read the information of the league that you attach to me, but I have the detail that I can not create as such in the table because it already exists, the table is related to a table of facts and I can not update everything, since it sends me error Due to the foreign keys, will there be another way to solve it?

On the other hand, the CDC option does not appear where the tutorial indicates