O'Reilly logo

Talend Open Studio Cookbook by Rick Barton

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Capturing individual rejects and errors

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.

Getting ready

Open the job jo_cook_ch07_0090_rejectsAndErrors.

How to do it…

The steps to be performed are as follows:

  1. Copy the customer table from metadata and create a tMysqlOutput component.
  2. Change the Table to "customer_reject_test", and change Action on table to Drop table if exists and create.
  3. Right-click the tMysqlOutput component and you will see that the only Row option is Main.
  4. Run the job. You will see that there are errors in the console and that the table ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required