I am trying to update one field(serverslno) in a table from another table (which is key column primary key of the table) based on a join condition, but it's not working.
I have a table actor inserting data to actor_new
tmysqlinput(actor) >> tmap>>tmysqloutput(actor_new) >>tmap>>tmysqlout(actor)
ID genrated in actor_new should go to one column called serverslno in actor. first insert is working fine but update not working.
Solved! Go to Solution.
in tMap,you have not mapped the Key column(that is input column for actor_id).
@TRF I understood. But this is not that case, here I want to update serverslno of actor with key column of actor_new. Previously it was a look up. but this is straight forward.
actor_id field is ticked as the Update Key for the update operation so it cannot be null.
As it is not mapped in the preceding tMap it is null so you need to add it.
Join us at the Community Lounge.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
View this on-demand webinar about APIs....