Preface
Introduction to PowerExchange for Google BigQuery
PowerExchange for Google BigQuery Configuration
- PowerExchange for Google BigQuery Configuration Overview
- Registering the PowerExchange for Google BigQuery Plug-in
  - Registering the PowerExchange for Google BigQuery Plug-in from the Administrator Tool
  - Registering the PowerExchange for Google BigQuery Plug-in from the Command Line Program
Google BigQuery Sources and Targets
Google BigQuery Mappings
- Google BigQuery Mappings Overview
- Source Filter
  - Configuring a Source Filter
Google BigQuery Sessions
Google BigQuery as CDC Target
Google BigQuery Pushdown Optimization
Appendix A: Google BigQuery Data Type Reference
- Data Type Reference Overview
- Google BigQuery and Transformation Data Types

PowerExchange for Google BigQuery User Guide for PowerCenter

10.5.6
- 10.5.9
- 10.5.8
- 10.5.7

Back Next

Configure the Java Heap Memory

When the source or target contains a large amount of data, configure the memory for the Java heap size on the node that runs the PowerCenter Integration Service. You must ensure that the minimum physical memory available on the server machine for each session is in the range of 300 to 500 MB.

You must set a maximum heap size value based on the amount of data that you want to process.

In the Administrator tool, navigate to the PowerCenter Integration Service for which you want to change the Java heap size.

On the

Processes

tab, edit the

General Properties

section.

Specify the maximum heap size in Java SDK Maximum Memory limit based on the amount of data you want to process.

Click

Restart the PowerCenter Integration Service.

Google BigQuery Sessions

Download Guide