Deleting rows in a table is quite simple.
Use a tMysqlOutput component and give it a flow which contains all columns you need to identify the rows to delete. Set all columns in this schema as key column and configure the tMysqlOutput in the Action on data to Delete.
For the table I would use a context variable. I guess you have to delete a couple of rows in some of your tables.
I would create a job which deletes the rows for exactly one table. But the table name is not fixed set instead the table name is a context variable and this variable have to be set from a surrounding job or within the job within a loop over your tables to process.
The first 100 community members completing the Open Studio survey win a $10 gift voucher.
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
Learn how and why companies are moving to the Cloud