kiran

• May 8th, 2005

 

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.

khadarbasha shaik

• Sep 12th, 2005

 

An active transformation can change the number is rows that pass throught it from source to target. i.e it discards the rows that doesn't meet the condition. where as passive transforamtion doesn't change the record count.

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

Active transformations

 

Advanced External Procedure

Aggregator

Application Source Qualifier

Filter

Joiner

Normalizer

Rank

Router

Update Strategy

  

Passive transformation

 

Expression

External Procedure

Maplet- Input

Lookup

Sequence generator

XML Source Qualifier

Maplet - Output

 

Cheers,

Sithu

premvijaykumar

 Profile 

• Aug 9th, 2006

 

if number of source = target it is passive transformation

if we can update or delete records it is active transformation

cheers,

prem

sheetal choudhary

• Apr 2nd, 2007

 

Hi ,

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.

Sheetal

Prodyot Sarkar

• Jul 31st, 2007

 

ACTIVE Transformations:Transformations those can affect the number of records between Input and Output.
Passive Transformations:Transformations those do not  affect the number of records between Input and Output.

Siraj khan

• Aug 6th, 2007

 

Active transformation are those transformation which changes the number of records..For example FILTER TRANSFORMATION.

Passive transformation are those transformation which does not changes the number of records.Record count is same for input as well as output..For Example Source Qualifier.

Fazululla_Shaik

 Profile Answers by Fazululla_Shaik 

• Oct 7th, 2007

 

Active Transformation

A Transformation which participates in changing the number of rows when the data is flowing from source to target.

Passive Transformation

A Transformation which doesn't participates in changing the number of rows when the data is flowing from source to target.


Fazululla Shaik

haribabu pulimi

 Profile Answers by haribabu pulimi 

• Jan 29th, 2008

 

ACTIVE :IF  NO OF INPUTS AND NO OF OUTPUTS ARE equal before and after the transformation


PASSIVE : NO OF INPUTS AND NO OF OUTPUTS ARE  equal before and after the transformation

ashok_psgmech

 Profile Answers by ashok_psgmech 

• Mar 18th, 2008

 

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.

Kalpana gopinath

 Profile Answers by Kalpana gopinath 

• Apr 4th, 2008

 

Active transformation is nothing but it will change the no of rows passing through it
(example) Filter transformation .In it when  we have 1000 rows as input after filter transformation according to the condition the output will be  modified

Passive transformation is nothing it will not  change the no of rows passing through it
(example) expression transformation .In it only extra column will be added but the rows will remain the same .

Suresh G

• May 1st, 2012

 

Conditional statements are also given in the Expression transformation then why it is passive transformation....

CHOTU JAIN

• Mar 13th, 2014

 

in expression,we may add extra port which can be used for making calculations on existing table columns.so it will simply calculate value for each record and will give it as output.

JNDeveloper

• Oct 15th, 2014

 

Active transformations are those that affect the number of rows between input and output. In addition, it is also considered active transformation when it changes the order of the rows like a "Sorter". I read so many threads saying "Sorter" is active because of the "Distinct" option. Well, I say, it is NOT because of that.

Passive transformations are those that retain the number of rows as well as order of rows between input and output.

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 TRANSFORMATION:- If the no. of records from the source is equal to the no. of records in the targets then those transformation is known as PASSIVE TRANSFORMATION. . .

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.