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:

Data Integration Service can push these operators to the following sources only when they are included in Filter transformation logic:
DB2 for
i5/OS
or
z/OS
Non-relational
SAP
You cannot push the
/ % || <> ^= not
operator to Non-relational sources.
Nonrelational sources are IMS, VSAM, and sequential data sets on
z/OS
.
You cannot push down
+ - * / % || not
operators to SAP sources.
You cannot push down
% ||
operators to ODBC sources.