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

Source SQL ELT optimization

Source
SQL ELT optimization

When the Secure Agent applies source
SQL ELT optimization
, it analyzes the mapping from source to target or until it reaches a downstream transformation it can't push to the source database.
The Secure Agent generates and executes a
SELECT
statement based on the transformation logic for each transformation it can push to the database. Then, it reads the results of this SQL query and processes the remaining transformations.
You can configure a mapping to use source
SQL ELT optimization
if the source and target reside in different databases. For example, if a mapping contains an Oarcle source and a Microsoft SQL Server target, you can configure source
SQL ELT optimization
to push some transformation logic for processing to the Oracle source.

0 COMMENTS

We’d like to hear from you!