When the File connector includes a reject link, records
that contain invalid data are automatically routed to the target stage
on the reject link.
About this task
When you configure a reject link, you can specify settings
to stop a job when records contain invalid data, to continue to process
the remaining records, or to send the records with invalid data to
the reject link.
Note: If you are in the implicit mode, make sure
that you specify the maximum column length for the reject column.
If
you do not define a reject link, the connector can still detect records
with invalid data and report the count at the end of the job. After
the job completes, you can evaluate the rejected records and adjust
the job and data.
Procedure
- On the job design canvas, add and configure a target stage
to receive the rejected records.
- Right-click the File connector and drag to create a link
from the File connector to the target stage.
- Double-click the connector to open the stage editor.
- Specify the reject link.
- On the Output page, select the link to the target stage
for rejected records from the Output name list.
- Click the Properties tab, and
then set the Is reject link property to Yes.
- Click the Properties tab in the Stage page and set the Reject
mode property to one of the following options:
Option |
Description |
Continue |
When a record contains invalid data, the File connector continues
to run the job and process records. |
Fail |
When a record contains invalid data, the job fails. |
Reject |
When a record contains invalid data, records that contain
invalid data are automatically routed to the target stage on the reject
link. The job continues to process the other records. |
- Click OK, and then save the job.