Effective in version 10.5, PowerExchange for Google BigQuery includes the following features:
When you perform pushdown optimization using the Google BigQuery ODBC connection, you can use the 126.96.36.1992 version of the Informatica ODBC Driver for Google BigQuery to connect to Google BigQuery and push CHR(), DATEDIFF(), DECODE(), LPAD(), and RPAD() functions to the Google BigQuery database.
Contact Informatica Global Customer Support to obtain the Informatica ODBC Driver for Google BigQuery.
You can use the Merge query to perform update, upsert, or delete operations in a single statement when you write to a Google BigQuery target.
When you configure a session to write data to Google BigQuery, you can write empty strings from a source as null values to a Google BigQuery target.
For more information, see the
Informatica 10.5 PowerExchange for Google BigQuery User Guide for PowerCenter