Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Data Integration Connectors
  • All Products

Table of Contents

Search

  1. Preface
  2. Introduction to PostgreSQL Connector
  3. Connections for PostgreSQL
  4. Mappings and mapping tasks with PostgreSQL Connector
  5. PostgreSQL objects in mapping tasks
  6. Lookup transformation
  7. SQL transformation
  8. Migrating a mapping
  9. PostgreSQL SQL ELT optimization
  10. Data type reference

PostgreSQL Connector

PostgreSQL Connector

Back Next

Configuring cross-schema SQL ELT optimization for PostgreSQL mapping

Configuring cross-schema
SQL ELT optimization
 for PostgreSQL mapping

Create two PostgreSQL mappings. For example, perform the following steps to configure cross-schema
SQL ELT optimization
 for a PostgreSQL
mapping
 task:
  1. Create the following two PostgreSQL ODBC connections, each defined with a different schema:
    1. Create an
      psql_odbc1
       PostgreSQL ODBC connection and specify
      PSQL_SCHEMA1
       schema in the connection properties.
    2. Create
      psql_odbc2
       PostgreSQL ODBC connection and specify
      PSQL_SCHEMA2
       schema in the connection properties.
  2. Create a PostgreSQL mapping,
    m_psql_pdo_acrossSchema
    . Perform the following tasks:
    1. Add a Source transformation and include a PostgreSQL source object and connection
      psql_odbc1
       to read data using
      PSQL_SCHEMA1
      .
    2. Add a Target transformation and include a PostgreSQL target object and connection
      psql_odbc2
       to write data using
      PSQL_SCHEMA2
      .
  3. Create a PostgreSQL
    mapping
     task, and perform the following tasks:
    1. Select the configured PostgreSQL mapping,
      m_psql_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 PostgreSQL source object associated with the
    PSQL_SCHEMA1
     schema and writes data to the PostgreSQL target object associated with
    PSQL_SCHEMA2
     schema.
0 COMMENTS
We’d like to hear from you!