You can enable cross-schema pushdown optimization for tasks that use source or target objects associated with different schemas within the same database. The Source and Target transformations must use two separate ODBC connections to run cross-schema pushdown optimization.
The DSN entry in the ODBC connection of the source, target, or lookup object must be the same. You can override the schema in the connection.
You can configure cross-schema pushdown optimization for the following databases when you use the ODBC connection:
Amazon Redshift
Microsoft Azure SQL Data Warehouse
PostgreSQL
Snowflake
Teradata
To configure cross-schema pushdown optimization in a mapping configuration task, perform the following tasks:
In the
Pushdown Optimization
section, on the
Schedule
tab, select the type of pushdown optimization.
In the
Advanced Session Properties
section, select the
Enable cross-schema pushdown optimization
check box.
The following image shows the configured
Enable cross-schema pushdown optimization
property in the advanced session properties of the mapping:
For more information about configuring cross-schema pushdown 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.
ASK INFAPreview
