Six Stars

Update not working in the job

Hi experts,

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

Capture2.JPGCapture3.JPGCapture4.JPGCapture.JPGCapture5.JPG

 

Please help.

1 ACCEPTED SOLUTION

Accepted Solutions
Twelve Stars

Re: Update not working in the job

do not check Updatable for actor_id

Manohar B
4 REPLIES
Employee

Re: Update not working in the job

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.

Six Stars

Re: Update not working in the job

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.

Twelve Stars

Re: Update not working in the job

do not check Updatable for actor_id

Manohar B
Employee

Re: Update not working in the job

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.