2017-06-21 12:00:50 UTC
I'm new in TDI and I need help with data sync between 2 tables (Delta). When I changed a value of a column in source table, a new row was inserted in destination table, there is no way to compare the values between this two tables / and remove the values in destination table, not present in source table, I don't want to remove all rows in the destination table, every time I need to syncronize this two tables.
JDBC Connector Source with Delta (Table A)
Read column Description of Table A
Delta column Description
Test -> changed to Test1
JDBC Connector Destination (Table B)