A Lookup transformation is considered passive by default because it processes one input row and returns one output row, maintaining the row count. It becomes an active transformation only when it is configured to potentially alter the number of rows. This occurs specifically when the "Lookup policy on multiple match" property is set to "Return All Values." In this configuration, if a single input row finds multiple matching records in the lookup source, the transformation will output a row for each match, thereby increasing the total row count and classifying it as active.

A. The "Use Any Value" policy still returns only a single row for each input row, even if multiple matches exist, thus the transformation remains passive.

B. This statement is false; a Lookup transformation can be configured to be active by enabling it to return all matching rows.

D. A Lookup is passive by default and only becomes active under the specific configuration of returning all rows on a multiple match.

1. Informatica PowerCenter 10.5

Transformation Guide

Chapter 11: Lookup Transformation

Page 278

Section: "Active Lookup Transformation".

The document states: "When you configure the Lookup transformation to return all matching rows

it becomes an active transformation... If you configure the Lookup transformation to return one matching row

it is a passive transformation."

2. Informatica PowerCenter 10.2.0

Transformation Guide

Chapter 11: Lookup Transformation

Page 273

Section: "Lookup Transformation Active or Passive".

This guide explicitly notes: "A Lookup transformation is an active transformation when the Lookup policy on multiple match is set to Return All Values. Otherwise

it is a passive transformation." This directly supports that only the "Return All Values" setting makes the transformation active.