Hi,
a newbie in Talend need your help. I am using TOS 3.2.2 to import data from xml files in a table in MSSQL. I want to do following:
1/ if the data does not exist in table, do an insert
2/ otherwise, do an update if and ony if any values have been changed.
By using tMap component and Lookup i can distinguish between insert and update (Looking up for primary keys of the table). But how can i tell Talend to do an update only if the values of fields have been changed. Thank you very much for any advise.
Hi thongMobi,
Can you share some snapshots so that we can see how you have implemented it?
Other members who have any other suggestions to above problem, please reply. Thanks.
