When a mapping contains a Lookup transformation (on a database table) or a Stored Procedure, the DTM (Data Transformation Manager which is created when a PowerCenter Integration Service executes a session) process would open connections as follows:
Pre-Session, Post-Session and Load Stored Procedures, if they have identical connection attributes (such as same connection name), the consecutive Stored Procedures reuse a connection.
The DTM process maintains a pool of connections for Lookups and Stored Procedures. If a connection is opened for a Lookup or a Stored Procedure it is not closed until the session completes. Hence, after Lookup or Stored Procedure finishes its task, the connection is returned to the pool. It can be reused for other Lookup or Stored Procedure when same connection value is specified in that Lookup/Stored Procedure as previous one.
What can we do to improve this information (2000 or fewer characters)