Determining the Num Parallel Workflows per EP Parameter Setting

Determining the Num Parallel Workflows per EP Parameter Setting

You set the Num Parallel Workflows per EP parameter value when you register the Informatica Integration Service in the Informatica Servers tab of the DAC Client. This parameter specifies the maximum number of workflows that can be executed in parallel on the Integration Service. If the number of sessions is zero or is not specified, the DAC Server assigns the default value of 10.
You should consider the following factors when determining the Num Parallel Workflows per EP parameter value:

• How powerful the machine is that hosts the Integration Service.
• How many instances of Integration Services are available.
• The number of Runnable tasks in the queue. A Runnable task is a task for which the Depends On tasks have completed and is ready to be run but is waiting for an Informatica slot to be available. For information about the different task run statuses, see.
  For an optimal run, the runnable queue should be at zero or should reach zero in a short time. For example, Figure 3-2 shows an ideal performance run when 15 sessions were run in parallel. There were many runnable tasks before the process began, but the queue soon reached zero.
  You can generate a run analysis such as Figure 3-2 from the right-click menu (select Get Run Information, then select Get Graph) on the DAC Current Runs and Run History tabs. If you find that the runnable curve does not reach zero in a short time, you should increase the Num Parallel Workflows per EP parameter value to make more Informatica slots available.

Figure 3-2 Sample Performance Run

Setting Informatica Integration Service Relaxed Code Page Validation

The Informatica Integration Service must be configured for relaxed code page validation. For more information, refer to the Informatica documentation.
To configure the Informatica Integration Service for relaxed code page validation

1. Log into Informatica Administrator.
2. Select the appropriate Integration Service.
3. Select the Properties tab.
4. In the Configuration Properties area, click Edit.
5. Deselect the ValidateDataCodePages check box.

Setting Informatica Integration Service Custom Properties

Follow this procedure to set custom properties for the Informatica Integration Service.
To set custom properties for the Informatica Integration Service

1. In Informatica Administrator, select the appropriate Integration Service.
2. Click the Properties tab.
3. In the Custom Properties area, click Edit.
4. Use the New option to display the New Custom Property dialog, and add the following custom properties:
   
   • Table 3-2 Custom Properties for Informatica Integration Service

     Custom Properties Name	Custom Properties Value	Notes
     ServerPort	<Server Port Number>	For <Server port number>, enter the number of an available port. For example, 4006. This custom property configures the Integration Service to listen on <Server port number>. DAC communicates with the Integration Service using this port.
     overrideMpltVarWithMapVar	Yes	Enables Informatica to evaluate parameters within mapplets.
     DisableDB2BulkMode	Yes	Add this custom property and set value to Yes if your Oracle Business Analytics Warehouse is on a DB2/390 or a DB2 UDB database.

5. Click OK to save the details.
6. Make sure that the Integration Service and Repository Service that you created during the Informatica PowerCenter installation are running.