I am new to Talend and am trying to achieve the following:
I have a table which has a key value (auto generated). It receives a null value (for the auto generated values). My data also contains the ID value which is the business key. I want to create a job which will do an upsert according to the business key (the ID column). The insert part is working (it is not writing any records a record with the ID already exists) however the update part is not working. What do I need to do in order to make it update the values according to a business key?
If Key attribute is auto generated value then remove that attribute from component and try to run job.
If you are updating any data in target table yes you need to keep key on business Key.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.