Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

Table of Contents

Search

  1. Introduction to ODBC Connector
  2. ODBC connections
  3. Synchronization tasks with ODBC Connector
  4. Mappings and mapping tasks with ODBC Connector
  5. Pushdown optimization (SQL ELT)
  6. Data type reference

ODBC Connector

ODBC Connector

Pushdown optimization variables

Pushdown optimization variables

When you use pushdown optimization, the Secure Agent converts the expression in the transformation by determining equivalent variables in the database. If there is no equivalent variable in the database, the Secure Agent processes the transformation logic.
The following table summarizes the pushdown optimization type for the available pushdown variables for supported databases:
Variables
Amazon Redshift
DB2
Google BigQuery
Microsoft Azure SQL Data Warehouse
Netezza
PostgreSQL
Snowflake
Teradata
SESSSTARTTIME()
-
-
Full
-
-
-
-
Full
SYSDATE()
-
Full
Source, Full
Source, Full
-
-
-
Full

0 COMMENTS

We’d like to hear from you!