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 - 13 of 13 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 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

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 transformation

if we can update or delete records it is active transformation

cheers,

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

  
Login to rate this answer.


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

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

  
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.

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.