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 (=)
  • Less than (<), greater than (>), less than or equal to (<=), greater than or equal to (>=)
  • Not equal to (!=)

Following the above rule ensures the lookup cache is parsed in the most efficient way.

Leave a Reply

Your email address will not be published. Required fields are marked *