Oracle Connector

Back Next

SQL ELT optimization functions

SQL ELT optimization
functions

When you use

SQL ELT optimization

, the Secure Agent converts the expression in the transformation by determining equivalent functions and pushes down the expression to process in the database. If there is no equivalent function in the database, the Secure Agent processes the transformation logic.

The following table summarizes the availability of

SQL ELT optimization

functions in Oracle:

Functions	SQL ELT optimization Type
ABS()	Source, Full
AVG()	Source, Full
COS()	Source, Full
COUNT()	Source, Full
DATE_COMPARE()	Source, Full
DECODE()	Source, Full
EXP()	Source, Full
IIF()	Source, Full
IN()	Source, Full
ISNULL()	Source, Full
LOWER()	Source, Full
MAX()	Source, Full
MIN()	Source, Full
POWER()	Source, Full
SIN()	Source, Full
SQRT()	Source, Full
SUM()	Source, Full
TAN()	Source, Full
UPPER()	Source, Full