Informatica - Session optimizing

Optimizing the Session

Once you optimize your source database, target database, and mapping, you can focus on optimizing the session. You can perform the following tasks to improve overall performance:

• Run concurrent batches.
• Partition sessions.
• Reduce errors tracing.
• Remove staging areas.
• Tune session parameters.

 lists the settings and values you can use to improve session performance:

Table 19-1. Session Tuning Parameters
Setting	Default Value	Suggested Minimum Value	Suggested Maximum Value
DTM Buffer Pool Size	12,000,000 bytes [12 MB]	6,000,000 bytes	128,000,000 bytes
Buffer block size	64,000 bytes [64 KB]	4,000 bytes	128,000 bytes
Index cache size	1,000,000 bytes	1,000,000 bytes	12,000,000 bytes
Data cache size	2,000,000 bytes	2,000,000 bytes	24,000,000 bytes
Commit interval	10,000 rows	N/A	N/A
Decimal arithmetic	Disabled	N/A	N/A
Tracing Level	Normal	Terse	N/A