topic Re: Update not working in the job in Talend Studio

Update not working in the job

DM2017 — Mon, 05 Feb 2018 05:57:26 GMT

Hi experts,

I have the above job, runs without error but not updating.

Please help.

Re: Update not working in the job

Anonymous — Mon, 05 Feb 2018 08:08:35 GMT

It appears that you haven't linked the actor_id from row1 to actor_id in ss. Effectively it's trying to do an update from the ss output with a blank key.

Try linking the two fields in the tMap and see the result.

Re: Update not working in the job

DM2017 — Mon, 05 Feb 2018 08:20:12 GMT

Hi,

Thanks for the reply, that's correct. Now I have a challenge. I need to lookup the table and update accordingly. How will be my design. I tried but not working.

tmysqlinput (table 1)>> lookup with tmysqlinput(table 2) >> tmap >> tmysqloutput(table1)

Basically updating table1 based on record on changes in table 2 for matching rows.

Please help if any work around.

Re: Update not working in the job

manodwhb — Mon, 05 Feb 2018 11:59:24 GMT

do not check Updatable for actor_id

Re: Update not working in the job

Anonymous — Tue, 06 Feb 2018 12:49:05 GMT

For your 2nd problem, use tMySqlInput for table 2 and link directly to tMySqlOutput for table 1. This should only update the matching records in table 1 where the primary key is the same as in table 2. As in the previous post, make sure that actor_id is not update-able.

Re: Update not working in the job

Tasfiahm — Thu, 02 Aug 2018 22:14:06 GMT

Thanks a lot for putting the question!!!

Re: Update not working in the job

Tasfiahm — Thu, 02 Aug 2018 22:17:45 GMT

Thanks @manodwhb for the solution. It will be very hard for me to find out the solution without out your contribution. Thanks again for teaching something new.