Table of Contents

Search

  1. Preface
  2. Introduction to Oracle Connector
  3. Connections for Oracle
  4. Synchronization tasks with Oracle Connector
  5. Mappings and mapping tasks with Oracle Connector
  6. Replication tasks
  7. Troubleshooting
  8. Appendix A: Data type reference

Oracle Connector

Oracle Connector

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

0 COMMENTS

We’d like to hear from you!