PostgreSQL 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 PostgreSQL objects associated with different schemas within the same PostgreSQL database.

To use cross-schema

SQL ELT optimization

, create two PostgreSQL ODBC 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.

PostgreSQL SQL ELT optimization

Configuring cross-schema SQL ELT optimization for PostgreSQL mapping

Download Guide

Watch

Comments

Cloud Connectivity Homepage