Answered by kiran on 2005-05-08 09:32:14: An active transformation can change the number of rows as output after a transformation, while a passive transformation does not change the number of rows and passes through the same number of rows that was given to it as input.

vipul kr

• Nov 29th, 2015

Hello Guys,

Do remember those transformations that change the order of records passing through it are also active transformation. like sorter without checking distinct option also said to be active.

JIYAJI

• Jan 14th, 2015

ACTIVE TRANSFORMATION:- If the no. of records from the source is not equal to the no. of records in the targets then those transformation is known as ACTIVE TRANSFORMATION. . . PASSIVE TRANSFORMATIO...

Answer Question  Select Best Answer