Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(4 Ratings)
facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

HOW TO: Improve performance of a session with a Lookup Transformation that has multiple conditions
Problem Description

A Lookup Transformation that has one condition in the session performs fine. However, a Lookup Transformation that uses multiple conditions has poor session performance.

Cause
Solution

To improve Lookup caching Performance when there are a mix of inequality ("<", ">", etc.) and equality ("=") conditions, always put the equality condition first then the Inequality conditions.

Example:

The following conditions (entered this order) in a Lookup transformation exhibit poor performance:

  1. empno => in_empno1
  2. empno < in_empno2
  3. empno = in_empno

The same conditions entered in the following order will improve performance:

  1. empno = in_empno
  2. empno => in_empno1
  3. empno < in_empno2
More Information
Applies To
Product: PowerCenter
Problem Type:
User Type: Administrator
Project Phase:
Product Version:
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:8/12/2014 10:02 PMID:17628
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)