Which of the below transformation can be used as connected and unconnected both way?
-
Stored procedure, Look up
-
Stored procedure, filter
-
Look up , joiner
-
Filter, Expression
Stored Procedure and Lookup transformations can be used in both connected and unconnected modes. In connected mode, they are part of the main data flow. In unconnected mode, they are called conditionally from other transformations using expressions. Filter, Joiner, and Expression transformations are only connected.
In Informatica PowerCenter, most transformations are strictly connected-only, but the Stored Procedure and Lookup transformations are the two that can be used either as connected (part of the mapping pipeline, receiving input row-by-row) or unconnected (called only when needed, e.g. from an expression via :LKP or a stored-procedure call). Filter and Expression are connected-only. Joiner is connected-only (it needs two data flows). So "Stored procedure, Lookup" is the correct pairing, and the other combinations mix in a transformation (filter, joiner, expression) that only supports connected mode.