By default, the PowerCenter Integration Service process creates a reject file for each target in the session. The reject file contains rows of data that the writer does not write to targets.
The writer may reject a row in the following circumstances:
It is flagged for reject by an Update Strategy or Custom transformation.
It violates a database constraint such as primary key constraint.
A field in the row was truncated or overflowed, and the target database is configured to reject truncated or overflowed data.
By default, the PowerCenter Integration Service process saves the reject file in the directory entered for the service process variable $PMBadFileDir in the PowerCenter Workflow Manager, and names the reject file
If you enable row error logging, the PowerCenter Integration Service process does not create a reject file.