The Definitive Guide to Data Quality
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.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.