Multiple choice technology

which of the following actions will improve lookup transformation performance?

  1. Cache only large lookup tables

  2. make sure the datatypes of both ports in the lookup condition match

  3. place condition with equality operator first

  4. place condition with conditional operator first
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Placing the condition with an equality operator first improves lookup performance because Informatica evaluates conditions in order and can quickly match on equality. Caching only large tables doesn't help if conditions are inefficient, matching datatypes prevents implicit conversion but doesn't optimize condition order, and conditional operators should come after equality checks.

Keep practicing — related questions