Preface
Introduction to Oracle Connector
- Oracle Connector assets
- Oracle Connector example
Connections for Oracle
Synchronization tasks with Oracle Connector
Mappings and mapping tasks with Oracle Connector
Replication tasks
Troubleshooting
Appendix A: Data type reference
- Oracle and transformation data types
  - Rules and guidelines for data types

Oracle Connector

Back Next

Cross-schema SQL ELT Optimization

Cross-schema
SQL ELT Optimization

You can use cross-schema

SQL ELT Optimization

for a

mapping

task to read from or write data to Oracle objects associated with different schemas within the same database.

To use cross-schema

SQL ELT Optimization

, create two Oracle connections and specify the schema in each connection. Ensure that the schema in the source connection is different from the schema in the target connection, but both the schemas must belong to the same database. When you configure

SQL ELT Optimization

for the

mapping

task, enable cross-schema

SQL ELT Optimization

in the advanced session properties. By default, the check box is selected.

SQL ELT optimization

Configuring cross-schema SQL ELT Optimization

Download Guide

Watch

Comments

Cloud Connectivity Homepage