✍ Kashif M
Trends

Sunday, 7 July 2013


Informatica - Session optimizing


By on July 07, 2013


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


Kashif
mkashu: Informatica - Session optimizing
Review : Kashif | Kashif
Update: July 07, 2013 | Rating: 4.5

Comment for "Informatica - Session optimizing "

0 comments

Post a Comment

Blog Archive