You can configure partitioning for Amazon Redshift sources and targets. You can configure the partition information so that the PowerCenter Integration Service determines the number of partitions to create at run time.
You can include a Pipeline Lookup transformation in a mapping.
The PowerCenter Integration Service can push expression, aggregator, operator, union, sorter, and filter functions to Amazon Redshift sources and targets when the connection type is ODBC and the ODBC Subtype is selected as Redshift.
You can configure advanced filter properties in a mapping.
You can configure pre-SQL and post-SQL queries for source and target objects in a mapping.
You can configure a Source transformation to select distinct rows from the Amazon Redshift table and sort data.
You can parameterize source and target table names to override the table name in a mapping.
You can define an SQL query for source and target objects in a mapping to override the default query. You can enter an SQL statement supported by the Amazon Redshift database.