In Informatica PowerCenter, an unconnected transformation is one that is not part of the direct data flow from source to target. Instead, it is called on-demand from another transformation (e.g., an Expression) to perform a specific task and return a value. The Lookup, Stored Procedure, and External Procedure transformations are the primary types that can be configured as either connected or unconnected. An unconnected Lookup is called using :LKP, an unconnected Stored Procedure using :SP, and an unconnected External Procedure using :EXTPROC within an expression. The other transformations listed, Java and Transaction Control, must be connected to the data pipeline to function.

B. Lookup, stored procedure, Java: The Java transformation must be connected to the data pipeline to process rows; it cannot be configured as an unconnected transformation.

C. Java, lookup, transaction control: Both the Java and Transaction Control transformations must be connected. The Transaction Control transformation specifically requires being in the data flow to manage transaction boundaries.

D. Transaction control, Java, lookup: Both the Transaction Control and Java transformations must be connected to the data pipeline and do not support an unconnected configuration.

1. Informatica PowerCenter 10.5 - Transformation Guide

Chapter 1: "Transformation Overview"

Section: "Connected and Unconnected Transformations". This section explicitly lists Lookup

Stored Procedure

and External Procedure as transformations that can be unconnected.

2. Informatica PowerCenter 10.5 - Transformation Guide

Chapter 16: "Lookup Transformation"

Section: "Connected and Unconnected Lookups". This section details the configuration and use of unconnected Lookup transformations

which are called from an expression.

3. Informatica PowerCenter 10.5 - Transformation Guide

Chapter 28: "Stored Procedure Transformation"

Section: "Connected and Unconnected Stored Procedure Transformations". This chapter confirms that a Stored Procedure can be run in unconnected mode to be called from another transformation.

4. Informatica PowerCenter 10.5 - Transformation Guide

Chapter 14: "Java Transformation"

Section: "Java Transformation Overview". The documentation describes the Java transformation as a component within the data flow (either active or passive) and does not mention an unconnected mode.

5. Informatica PowerCenter 10.5 - Transformation Guide

Chapter 30: "Transaction Control Transformation"

Section: "Transaction Control Transformation Overview". This section describes the transformation as an active

connected transformation used to define commit and rollback points for data passing through it.