The PowerCenter Integration Service generates a success file after you run a session. The success file contains an entry for each record that successfully writes into Amazon Redshift. Each entry contains the values that are written for all the fields of the record. Use this file to understand the data that the PowerCenter Integration Service writes to the Amazon S3 bucket and then to the Amazon Redshift target.
If you want the PowerCenter Integration Service to generate a success file, specify a directory for the success file in the session properties. Specify a directory on the machine that hosts the PowerCenter Integration Service.