You can implement pushdown optimization to improve the performance of a PowerCenter session that uses a Google BigQuery mapping. To configure a pushdown optimization in a Google BigQuery session, perform the following tasks:
Import the Google BigQuery ODBC source table or tables.
Create a Google BigQuery ODBC connection.
Create a Google BigQuery mapping.
Create a Google BigQuery session.
Configure a session for full pushdown optimization.