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.
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