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

Full SQL ELT optimization

Full
SQL ELT optimization

When the Secure Agent applies full
SQL ELT optimization
, it pushes all the transformation logic in the mapping to the target database.
You can configure full
SQL ELT optimization
in the
SQL ELT Optimization
section.
Full
SQL ELT optimization
is ideal when the source and target are in the same connections. For example, if a mapping contains an Oracle source and an Oracle target, configure full
SQL ELT optimization
to push all the transformation logic for processing from an Oracle source database to an Oracle target database.

0 COMMENTS

We’d like to hear from you!