What are the types of Lookup Transformation?
-
Passive
-
Connected
-
Unconnected
-
Active
A,B,C
Correct answer
Explanation
Informatica Lookup transformations are primarily categorized as connected or unconnected depending on their integration in the mapping pipeline. They are also typically passive because they return a single row for each lookup query, whereas active lookups returning multiple rows are a distinct, less common configuration.