You can use PowerExchange for Google BigQuery for connectivity between PowerCenter and Google BigQuery.
You can use Google BigQuery objects as sources and targets in mappings. When you use Google BigQuery objects in mappings, you must configure properties specific to Google BigQuery.
Example
Your organization is an open source log data collector, which collects log data from multiple sources and unifies them.
Logs help you understand how systems and applications perform. As the scale and complexity of the system increases, it is difficult to manage multiple logs from different sources.
To overcome this problem, you can use PowerExchange for Google BigQuery to write data to a Google BigQuery target and query terabytes of logs in seconds. You can then use the data to fix and improve the system performance in near real time.