Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

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

Feedback

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?

Example

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?

Cause
Solution

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
Database:
Operating System:
Other Software:

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

Feedback

Did this KB document help you?



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