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

SQL ELT optimization

When you read data from an Oracle source, transform the data, and write the data to a target, you can configure
SQL ELT optimization
to push the transformation logic to the source or target database system. If the source and target databases are the same, you can configure full
SQL ELT optimization
for improved performance.
When the Secure Agent applies
SQL ELT optimization
, it pushes transformation logic to a database. The Secure Agent translates the transformation logic into SQL queries and sends the SQL queries to the database. The database runs the SQL queries to process the transformations.
SQL ELT optimization
improves mapping performance when the database can process the transformation logic faster than the Secure Agent. The Secure Agent also reads less data from the database.
The amount of transformation logic that the Secure Agent pushes to the database depends on the database, the transformation logic, and the
mapping
task. The Secure Agent processes all transformation logic that it cannot push to a database.
When you configure
SQL ELT optimization
for the mapping, the Secure Agent analyzes the optimized mapping from the source to the target or until it reaches a downstream transformation that it cannot push to the source database. The Secure Agent generates and executes a
SELECT
statement for each source that has transformation logic pushed down. Then, it reads the results of this SQL query and processes the remaining transformations in the mapping.
When you push transformation logic to the database, ensure that the database has enough resources to process the queries faster. Otherwise, there could be a performance degradation.
You cannot configure
SQL ELT optimization
for a mapping in advanced mode.
The Secure Agent can push the following transformation logic to an Oracle source
or target
:
Transformations
Supported
SQL ELT optimization
Type
Aggregator
Source, Full
Expression
Source, Full
Filter
Source, Full
Joiner
Source, Full
Sorter
Source, Full
Union
Source, Full
Router
Full

0 COMMENTS

We’d like to hear from you!