When you use pushdown optimization, the Integration Service converts the expression in the transformation or workflow link by determining equivalent operators in the database. If there is no equivalent operator, the Integration Service processes the transformation logic.
You can push the following operators to the database using full pushdown optimization:
+ - * / % ||= > < >= <= <> != ^= not and or
Consider the following exceptions to operators:
You cannot push the
operator to Amazon Redshift.
You can push down
= > < >= <= <> != ^= not and or
operators to Amazon Redshift using source pushdown optimization.
You cannot push down the % operator to Greenplum.
You can push down the
operator to IBM DB2, Microsoft SQL Server, Sybase ASE, Teradata, and Azure DW using source-pushdown optimization.