Many applications will write to/delete from the same table in many different ways, using different fields as keys and often updating different fields at different times. This recipe shows how this can be achieved without having to create new schemas each time.
Open the job
The steps to be performed are as follows:
tMysqlOutputcomponent and change the field Action on data from Insert to Insert or update.