Select the ODBC subtype in the ODBC connection to push the transformation logic to the database. You can specify the ODBC subtype in the ODBC connection object definition.
You can configure a specific ODBC subtype for the following ODBC connection types:
Google Big Query
Default is None. When you select the ODBC subtype as None, the PowerCenter Integration Service cannot push transformation logic to the database.