Amazon Redshift Lookups in Data Synchronization Tasks
When you configure field mappings in a Data Synchronization task, you can create an uncached lookup to an Amazon Redshift object. Use the JDBC URL specified in the connection properties to create an uncached lookup.
Note: Amazon Redshift Connector does not support un-connected lookup transformation.
For more information about, see "Lookup Transformation" in the PowerCenter Transformation Guide.