Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(1 Rating)
facebook Twitter
Print Bookmark Alert me when this article is updated


FAQ: Does a PowerCenter session allocate memory for each transformation cache independently?
Problem Description

When running a PowerCenter session with multiple caching transformations, is the memory used by each transformation cache released before each downstream transformation cache allocates memory?


If a session allocates 500MB for a Sorter transformation cache and 500MB for the Joiner transformation cache, is the Sorter memory released before it proceeds with the Joiner?


PowerCenter sessions allocated the entire memory specified for all transformations in the mapping and holds on to all of the memory until the session is finished.

In this example the memory allocated for the Sorter will be heldtill the end of the session (so does the Joiner memory and all other Transformation memory).

More Information
Applies To
Product: PowerCenter
Problem Type:
User Type: Administrator
Project Phase:
Product Version: PowerCenter
Operating System:
Other Software:

PowerCenter Advanced Workflow Guide > "Session Caches" > "Configuring the Cache Size"
Last Modified Date:12/14/2010 3:52 PMID:18952
People who viewed this also viewed


Did this KB document help you?

What can we do to improve this information (2000 or fewer characters)