PowerExchange for Vertica User Guide for PowerCenter

10.4.0
- 10.5.4
- 10.5

Back Next

Rejected File

When you run a session in bulk mode, you can configure the PowerCenter Integration Service to write the rejected records to a rejected file. The rejected file contains all the records that were rejected by the copy command and not written to the Vertica target.

The rejected file displays the record details of each column separated by a | character. Therefore, if you have sensitive data, you must encrypt the data before you run the session.

If you use partitions, the PowerCenter Integration Service creates a rejected file for each partition.

By default, the PowerCenter Integration Service creates the rejected file in the following path:

$PMRootDir/Temp/

If you want to change the default path, you can define the path in the session properties.

The PowerCenter Integration Service uses the following naming convention for the rejected file:

RejectedData_PartNum_[Partition_Number]_[Table Name]_[Schema Name]_[Counter]_<milliseconds*1000>.dat

Sample Rejected File

"-9223372036854775808"|"-9223372036854775808"|"-9223372036854775808"|"-9223372036854775808"|"-9223372036854775808"|"-9223372036854775808"|"-9223372036854775808"|"-9223372036854775808"|"-9223372036854775808"|"-9223372036854775808"|"-9223372036854775808"|"-9223372036854775808"|"-9223372036854775808"|"-9223372036854775808"|"-9223372036854775808"|"-9223372036854775808"|"-9223372036854775808"|"-9223372036854775808"

Rename Saved Search

Table of Contents

PowerExchange for Vertica User Guide for PowerCenter

PowerExchange for Vertica User Guide for PowerCenter

Rejected File

Rejected File

Sample Rejected File