When you use pushdown optimization, the PowerCenter Integration Service converts the expression in the transformation or workflow link by determining equivalent operators, functions, and variables in the database.

PowerExchange for HANA supports the following transformations for pushdown optimization:

Transformations Supported	Pushdown Type
Aggregator	Source, Target, Full
Expression	Source, Target, Full
Filter	Source, Target, Full
Joiner	Source, Target, Full
Lookup	Source, Target, Full
Sorter	-
Union	Source, Target, Full
Router	Source, Target, Full
Update Strategy	Source, Target, Full
Source Qualifier

The PowerCenter Integration Service can push the following arithmetic, comparison, and logical pushdown operators to an SAP HANA database by using source-side, target-side, or full pushdown optimization:

The PowerCenter Integration Service can push the following variables to an SAP HANA database by using source-side, target-side, or full pushdown optimization:

SESSSTARTTIME
SYSDATE