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.
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:
