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