Talend update a column in more than one table in talend ata time
i want to update a a column value from x to y in multiple tables . Can i create a single talend job to perform this action. Note: table are of diffent schema but the column i want to update is present in all the tables.
You can pass the tablelist in string variable separated by comma for example and can use tnormalize to get the tablelist one by one and pass the tablelist variable to the update query in t[sql]row component
This Java scenario describes a two-component Job that updates data in a MySQL table according to that in a delimited file. For more technologies supported.
