In the

Config Object

settings of each PowerCenter workflow, increase the number of partitions that PowerCenter uses when it processes files to a minimum of 8 partitions for a throughput of 100 events per second. For example, define 24 partitions for a throughput of 300 events per second.

In the Generate_File_Path transformation, select the

Do not use a temporary folder in the generated file path

check box to copy the file directly to the Data Exchange document store instead of in a temporary location. By default, PowerCenter copies each file first to a temporary location and then to the Data Exchange document store. If you select this check box, PoweCenter maintains only one copy of each file.

The Add_Document_To_Event transformation may significantly impact the workflow processing time. If you include the transformation in the workflow, you can minimize the performance impact in the following ways:

Add a document to an event only when a processing error occurs.
For a parent event with multiple child events, aggregate the documents to a single file and attach it to the parent event.
If the average row size in the document is smaller than 4KB, pass the document by value. This prevents PowerCenter from writing too many documents to the Data Exchange Document Store.
If the average row size in the document is larger than 4KB, pass the document by reference with the Generate_File_Path transformation.

On an SQL server with the Windows operating system:

Use the Profile_Parameter transformation once in the beginning of the workflow to retrieve all the parameters instead of multiple times in the workflow to retrieve individual parameters.
The Set function of the Event_Attributes transformation may drastically reduce performence. If you need to use the function, you can set all of the attributes once for the parent event.
The Initiate_Correlation and Complete_Correlation transformations may drastically reduce performance.

To optimize API calls to

B2B Data Exchange

from PowerCenter, set the PowerCenter Integration Service environment variable

DX_JCT_MAX_ROWS_IN_BATCH

to 10.