topic Re: Upsert using Action on data in the tDBOutPut component in Talend Studio

Upsert using Action on data in the tDBOutPut component

Anonymous — Thu, 03 May 2018 15:46:22 GMT

Hi,

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?

Re: Upsert using Action on data in the tDBOutPut component

vboppudi — Thu, 03 May 2018 15:53:04 GMT

If Key attribute is auto generated value then remove that attribute from component and try to run job.

Regards,

Re: Upsert using Action on data in the tDBOutPut component

Anonymous — Thu, 03 May 2018 16:01:15 GMT

vboppudi great thanks! worked like magic!

Do I need to keep the key definitions on the Business key?

Re: Upsert using Action on data in the tDBOutPut component

vboppudi — Thu, 03 May 2018 16:03:09 GMT

If you are updating any data in target table yes you need to keep key on business Key.

Regards,