property in the session properties of the mapping task when the Source transformation has the following configurations:
Filter or joiner in the query options of the source.
Custom SQL query
Mappings enabled for pushdown optimization has the following restrictions for sources:
Mappings fail to read data from two Snowflake sources that have fields with the same name and you define a filter condition for one of the common fields.
To run a SQL query to read from tables where the names contain unicode characters, add a custom flag
OdbcUseUnicodeAPI
and set the value to 1 for the service of type Data Integration Server in the Secure Agent properties.
ASK INFAPreview
