GeekInterview.com
Series: Subject: Topic:
Question: 68 of 76

What are active transformation / Passive transformations?


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.
Asked by: Interview Candidate | Asked on: May 8th, 2005
Showing Answers 1 - 14 of 14 Answers
kiran

Answered On : 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.

  
Login to rate this answer.
khadarbasha shaik

Answered On : 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.

  
Login to rate this answer.
sithusithu

Answered On : Jan 24th, 2006

View all answers by sithusithu

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 transformationActive transformations Advanced External ProcedureAggregatorApplication Source QualifierFilterJoinerNormalizerRankRouterUpdate Strategy  Passive transformation ExpressionExternal ProcedureMaplet- InputLookupSequence generatorXML Source QualifierMaplet - Output  Cheers,Sithu

Yes  2 Users have rated as useful.
  
Login to rate this answer.
premvijaykumar

Answered On : Aug 9th, 2006

if number of source = target it is passive transformationif we can update or delete records it is active transformationcheers,prem

  
Login to rate this answer.
sheetal choudhary

Answered On : 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

  
Login to rate this answer.
Prodyot Sarkar

Answered On : 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.

  
Login to rate this answer.
Siraj khan

Answered On : 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.

  
Login to rate this answer.

Active TransformationA Transformation which participates in changing the number of rows when the data is flowing from source to target.Passive TransformationA Transformation which doesn't participates in changing the number of rows when the data is flowing from source to target.Fazululla Shaik

  
Login to rate this answer.

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

  
Login to rate this answer.
ashok_psgmech

Answered On : Mar 18th, 2008

View all answers by ashok_psgmech

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.

Yes  1 User has rated as useful.
  
Login to rate this answer.

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  modifiedPassive 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 .

  
Login to rate this answer.
Suresh G

Answered On : May 1st, 2012

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

  
Login to rate this answer.
CHOTU JAIN

Answered On : 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.

  
Login to rate this answer.
JNDeveloper

Answered On : 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.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.