Multiple choice technology

Lookup transformation is a _______________ type

  1. Connected, Unconnected and Passive

  2. Connected, Unconnected and active

  3. Depends on Business requirement

  4. Cannot specify

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Lookup transformations in Informatica have three types: Connected (part of the data flow pipeline), Unconnected (called via expression), and Passive (doesn't change row count). The distinction 'Passive' vs 'Active' is fundamental - Active transformations change row count, Passive ones don't.