A Lookup Transformation that has one condition in the session performs fine. However, a Lookup Transformation that uses multiple conditions has poor session performance.
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.
The following conditions (entered this order) in a Lookup transformation exhibit poor performance:
empno => in_empno1
empno < in_empno2
empno = in_empno
The same conditions entered in the following order will improve performance:
What can we do to improve this information (2000 or fewer characters)