Create a mapping with an Amazon Redshift source to read data from Amazon Redshift. Create a mapping with any source and an Amazon Redshift target to write data to Amazon Redshift. You cannot use the
Create Target
option from the advanced target session properties on an Amazon Redshift target using the PowerCenter Client.
Dynamic partitioning does not work for PowerExchange for Amazon Redshift.