sithusithu

 Profile Answers by sithusithu 

• Jan 24th, 2006

 

Transformations can be active or passive. An active transformation can change the number of rows that pass through it, such as a Filter transformation that removes rows that do not meet the filter condition.

A passive transformation does not change the number of rows that pass through it, such as an Expression transformation that performs a calculation on data and passes all rows through the transformation.

Cheers,

Sithu

chandrarekha

• Sep 6th, 2007

 

Active Transformation : A Transformation which change the number of rows when data is flowing from source to target

Passive Transformation : A transformation which does not change the number of rows when the data is flowing from source to target

sasi.a.kumar

 Profile Answers by sasi.a.kumar 

• Aug 14th, 2009

 

Passive Transformation: When the number of input records to a transformation is equal to the number of output records from the transformation then we call that transformation as Passive Transformation. for Example Expression Transformation, whatever may be the case the number of recordsgiven and got from the transformation will be equal.

Active Transformation: When the number of input records given to a transformation does not equals to the number of records got from the transformation then that transformation is called active transformation, A best example for active transformation is Filter Transformation.

All active transformation(Except Router) Will have less or equal* number of outputs (rows) than the input.

*Note: I have mentioned equal because in some cases the number of input and output records passed to an active transformation may be equal. A best example is Sorter transformation where most of the time the number of i/p records match the No. of o/p records, but the Sorter transformation has the ability to filter distinct records.

avneeshrathor

 Profile Answers by avneeshrathor 

• Nov 3rd, 2009

 

Thats not correct. By this definition Update Strategy should be a passive transformation but it is not.

So correct answer is that any transformation which can change 1. Number of rows 2. Row type i.e. DD_INSERT, DD_DELETE... 3. Transaction control... All these are active ones.