Gathering all rejects prior to killing a job

As an alternative to collecting incorrect rows up to the point where a job fails (Die on error), you may wish to capture all rejects from an input before killing a job.

This has the advantage of enabling support personnel to identify all problems with source data in a single pass, rather than having to re-execute a job continually to find and fix a single error / set of errors at a time.

Getting ready

Open the job jo_cook_ch03_0010_validationSubjob. As you can see, the reject flow has been attached and the output is being sent to a temporary store (tHashMap).

How to do it…

1. Add the tJava, tDie, tHashInput, and tFileOutputDelimited components.

2. Add onSubjobOk to tJava from the tFileInputDelimited component.

3. Add a flow from the tHashInput component to the tFileOutputDelimited component.

4. Right-click the tJava component, select Trigger and then Runif. Link the trigger to the tDie component. Click the if link, and add the following code

   ((Integer)globalMap.get...