My scenario is like, I have the tMysqloutput component is like as follows
tmysqloutput---> Basic settings --->Action on table is Default and Action on Data is Update
tmysqloutput---> Advanced settings-----> Use field options
You can find the image in the attachment
In the image you can observe, I want to update indicator (indicator is key column also), but i am unable to update the indicator
Thanks in Advance,
You have a primary key defined in the schema?
In Java project, there is a 'die on error' option on the compopnent. Please check it to see if you can catch some error when try to update your key value in your job?
thanks for giving answer
it did not throw any errors but required column is not updated....
Have you already defined a primary key in the schema? Could you please also post your basic settings of your tMySqlOutput component screenshot here(please mask your sensitive data)
Is your issue fixed now? Feel free to post your issue here.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema