Multiple choice technology

When lookup transformation is configured to use dynamic cache ---- operator can be used in lookup condition

  1. <>

  2. >=

  3. =

  4. <>,>=,=
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

When a lookup transformation is configured to use dynamic cache in Informatica (or similar ETL tools), only the equality operator (=) can be used in the lookup condition. Dynamic cache requires an exact match on the lookup key to determine whether to insert, update, or reject rows based on cache contents. Operators like <> or >= would require range comparisons that dynamic cache cannot efficiently support.

Keep practicing — related questions