When using tMySQLOutputBulkExec to update rows, how do you specify which columns are to be updated and which should be used as keys?
@devmichael,in the edit schema of tMySQLOutputBulkExec ,you cna define key column and the other columns what are you mentioned will be updated based on key column.
I currently select columns I wish to be used to lookup records as keys, and everything remaining I expect to be updated. I then go into Advanced Settings and set 'Action on Data' to be 'Update records in table'. When I do this, certain fields end up blank. I don't think it's a constraint or not null issue but before I took more time with it, I wanted to make sure the above was reasonable.
@devmichael,in data based side there is proper defining key on the key columns ,then the solution which i provide will work perfectly. if you have any other contains in database side you need to sort out.
@devmichael,still do you have issue?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables