An active transformation is one that can change the number of rows in the data flow, alter the transaction boundary, or change the row type. The transformations listed in option D—Router, Update Strategy, and Joiner—are all unequivocally classified as active. The Router can filter or redirect rows, the Update Strategy flags rows for different database operations (insert, update, delete), and the Joiner can change the row count based on the join condition and type. Therefore, this is the only selection where all transformations are always active.

A. This option includes the Expression transformation, which is passive. It operates on each row individually without changing the total number of rows.

B. This option also includes the Expression transformation, a passive transformation that cannot alter the row count passing through it.

C. This option includes the Stored Procedure transformation, which can be configured as either active or passive, so it is not guaranteed to be active.

1. Informatica PowerCenter 10.5 - Transformation Guide

Chapter 1: Transformations

"Active and Passive Transformations"

Page 10.

This section explicitly defines active and passive transformations. It lists Router

Update Strategy

and Joiner as active transformations because they can change the number of rows. It lists Expression as a passive transformation. It also notes that a connected Stored Procedure can be active or passive.

2. Informatica PowerCenter 10.2.0 - Transformation Guide

"Preface"

Informatica Conventions

Page 6.

This section provides a clear list of transformations categorized as Active or Passive. Router

Update Strategy

and Joiner are listed under "Active transformations". Expression is listed under "Passive transformations". This confirms that options A and B are incorrect.

3. University of Washington

CSE 444: Database Systems Internals

Lecture 19: "Data Warehousing and ETL".

Course materials on ETL processes often describe Informatica transformations. Slides from such courses typically classify transformations

noting that components like Filters

Aggregators

and Routers are 'active' as they modify the number of tuples (rows) in the data stream

whereas transformations like Expression are 'passive'. This academic context supports the official vendor classification.