You can configure cross-database

SQL ELT optimization

in the mapping task. You must ensure that the source and target transformations in the mapping must use two different ODBC connections that point to different database DSN entries.

You can configure cross-database

SQL ELT optimization

for the following database when you use the ODBC connection:

Snowflake

To configure cross-database

SQL ELT optimization

in a mapping configuration task, perform the following tasks:

In the
Runtime Options
page of the mapping configuration task, navigate to the
Advanced Session Properties
section.
Click
Add
to add a new session property.
From the
Session Property Name
list, select
Allow SQL ELT across Databases
and set the
Session Property Value
to
Yes
.

For more information about configuring cross-database

SQL ELT optimization

to read from or write data to objects associated with different schemas within the same database and for examples, see the help for the relevant connector.