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: Can a PowerCenter session be configured to build lookup caches concurrently?
Solution

The Integration Service can build lookup caches for multiple connected Lookup transformations concurrently.
This can improve performance in sessions which are currently using sequential caching.
The concurrent caching for multiple lookup transformations can be configured using the session level attribute Additional Concurrent Pipelines for Lookup Cache Creation which is part of the session config object.

When performing concurrent caching, the Integration Service can also start building the cache as soon as the session starts and does not need to wait for data to reach the Lookup transformation. It does not wait for upstream transformations to complete before it creates lookup caches, and it does not need to finish building a lookup cache before it can begin building other lookup caches.

For new PowerCenter new sessions this attribute is set to "Auto" and in this case Integration service will automatically determine an appropriate value.
For upgraded sessions the value is set to zero and this feature is disabled, but it can be changed from zero ("0") to auto or something larger than zero.

More Information

NOTE:

The unconnected Lookup transformation cache is always built sequential, regardless of value specified.

Reference
For further details regarding this feature with illustrations refer to "Building Connected Lookup Caches" under "Lookup Caches" in the PowerCenter Transformation Guide.
Applies To
Product: PowerCenter
Problem Type:
User Type: Developer
Project Phase:
Product Version: PowerCenter
Database:
Operating System:
Other Software:
Attachments
Last Modified Date:12/17/2010 1:29 PMID:19426
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)