Many database applications require a log of rejects and errors to be kept to enable erroneous records to be identified, so that manual repairs can take place. This recipe shows how to capture errors for individual rows using the reject row facility.
Open the job
The steps to be performed are as follows:
customertable from metadata and create a
"customer_reject_test", and change Action on table to Drop table if exists and create.
tMysqlOutputcomponent and you will see that the only Row option is Main.