Effective in version 10.1.1 Update 2, you can select multiple schemas for Amazon Redshift objects. To select multiple schemas, leave the

Schema

field blank in the connection properties. In earlier releases, selecting schema was mandatory and you could select only one schema.

If you upgrade to version 10.1.1 Update 2, the PowerExchange for Redshift mappings created in earlier versions must have the relevant schema name in the connection property. Else, mappings fail when you run them on version 10.1.1 Update 2.

For more information, see the

Informatica 10.1.1 Update 2 PowerExchange for Amazon Redshift User Guide

.