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

Configuring cross-schema SQL ELT Optimization

Configuring cross-schema
SQL ELT Optimization

Consider the following steps to configure cross-schema
SQL ELT Optimization
for an Oracle
mapping
task:
  1. Create the following two Oracle connections, each defined with a different schema:
    1. Create an
      orc_1
      Oracle connection and specify
      CQA_SCHEMA1
      schema in the connection properties.
    2. Create
      orc_2
      Oracle connection and specify
      CQA_SCHEMA2
      schema in the connection properties.
  2. Create an Oracle mapping,
    m_Orc_pdo_acrossSchema
    . Perform the following tasks:
    1. Add a Source transformation and include an Oracle source object and connection
      orc1
      to read data using
      CQA_SCHEMA1
      .
    2. Add a Target transformation and include an Oracle target object and connection
      orc2
      to write data using
      CQA_SCHEMA2
      .
  3. Create an Oracle
    mapping
    task, and perform the following tasks:
    1. Select the configured Oracle mapping,
      m_Orc_pdo_acrossSchema
      .
    2. On the
      Runtime Options
      tab, in the
      SQL ELT Optimization
      section, set the
      SQL ELT Optimization
      value to
      Full
      .
    3. In the
      Advanced Session Properties
      section, select the
      Enable cross-schema SQL ELT Optimization
      check box.
    4. Save the task and click
      Finish
      .
    When you run the
    mapping
    task, the Secure Agent reads data from the Oracle source object associated with the
    CQA_SCHEMA1
    schema and writes data to the Oracle target object associated with
    CQA_SCHEMA2
    schema.

0 COMMENTS

We’d like to hear from you!