Lookups in Informatica are classified into two types: Connected lookup (part of the data flow pipeline, receives input rows directly) and Unconnected lookup (called from within another transformation using :LKP reference, not directly in data flow). Active and passive refer to transformation types, not lookup categories. Connected vs unconnected determines how the lookup is invoked and whether it's part of the main flow.