I have the above job, runs without error but not updating.
Solved! Go to Solution.
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.
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.