PowerExchange for Amazon Redshift User Guide for PowerCenter

10.5.2
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.4.1
- 10.5.4

Back Next

Amazon Redshift Mappings Overview

After you import an Amazon Redshift source or target definition into the PowerCenter repository, you can create a mapping to read data from an Amazon Redshift source or write data to an Amazon Redshift target.

You can read data from a single Amazon Redshift source and write data to a multiple Amazon Redshift targets.

When you create a temporary table for an upsert, update, or delete operation in the local staging area, you must create the temporary table in the following format:

RecordName + "_" + time-stamp + ProcessID + PartitionId

By default, you have the permission to create the temporary tables as you have the PUBLIC group membership. To deny the permission, revoke the TEMP permission from the PUBLIC group and allow the TEMP permission to specific or groups of individuals.

For information on the Performance Tuning and Sizing Guidelines, see https://docs.informatica.com/data-integration/powerexchange-adapters-for-powercenter/h2l/1110-performance-tuning-and-sizing-guidelines-for-powerexchange-/abstract.html

Rename Saved Search

Table of Contents

PowerExchange for Amazon Redshift User Guide for PowerCenter

PowerExchange for Amazon Redshift User Guide for PowerCenter

Amazon Redshift Mappings Overview

Amazon Redshift Mappings Overview