Multiple choice technology

Can we filter the records with lookup?

  1. Yes

  2. No

  3. Lookup is not filtering it will throw error

  4. Need to write override query
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In Informatica, a Lookup transformation can be used to filter records. For example, if a lookup finds no match (returning NULL values), subsequent transformations (like a Filter) can drop those records based on the lookup's output. Thus, filtering via lookup is possible.

Keep practicing — related questions