How to optimize lookup conditions for best performance?

Informatica lookup can contain several conditions to match incoming row with the lookup cache. The order of these conditions also determines how much time the lookup takes to match and return a row. For better performance follow below order to arrange your conditions to get the best performance out of your lookup transformation:- Equal to (=) […]