Rules and Guidelines for Full Pushdown Optimization
Rules and Guidelines for Full Pushdown Optimization
Consider the following rules and guidelines when you configure full pushdown optimization:
The Data Integration Service can push all transformation logic in the mapping to IBM DB2, Microsoft SQL Server, Oracle, and ODBC sources such as Amazon Redshift, Greenplum, Netezza, Teradata, and SAP HANA.
When you configure full pushdown optimization for a mapping with an Update Strategy transformation, you can use the Update else Insert strategy only for Amazon Redshift, Oracle, and Teradata.