Before writing data to Amazon Redshift target tables, database ingestion jobs stage the data in an Amazon S3 bucket. You must specify the name of the bucket when you configure the database ingestion task. The ingestion jobs use the

COPY

command to load the data from the Amazon S3 bucket to the Amazon Redshift target tables. For more information about the

COPY

command, see the Amazon Web Services documentation.

When you define a connection for an Amazon Redshift target, provide the access key and secret access key for the Amazon S3 bucket in which you want the database ingestion jobs to stage the data before loading it to the Amazon Redshift target tables.

Incremental load jobs and combined initial and incremental load jobs generate a recovery table named INFORMATICA_CDC_RECOVERY on the target to store internal service information. The data in the recovery table prevents jobs that are restarted after a failure from propagating previously processed data again. The recovery table is generated in the same schema as the target tables.