Synchronize data between different table

[modara]

hi,

I have two mysql table

here Personal_ID is the primary Key

table_input

here also Personal_ID is the

primary Key

I have another output table table_output

i am using talend open studio to migrate data from table_input to table_out and all 6 data came from table_input to table_out

my table_input configuration is

tMap configuration is

and table_out configuration is

So the issue is when I insert new data into table_input I want to get an update only that new data, not all / everything from table_input.

please help me with where is my issue is.. several times i have tried but failed

[Anonymous]

@Not defined Not defined​ , you need the Change Data Capture (CDC) functionality which is only available on enterprise subscription products, it captures the change data and update them into target table, for more details about CDC, see this documentation page. Without CDC, all data are read from input table and updated into target table even though some of data aren't changed.