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.