GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  ETL
Go To First  |  Previous Question  |  Next Question 
 ETL  |  Question 9 of 58    Print  
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.



  
Total Answers and Comments: 11 Last Update: April 04, 2008   
  
 Sponsored Links



 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
  Sorting Options  
  Page 1 of 2   « First    1    2    >     Last »  
May 08, 2005 09:32:14   #1  
kiran        

RE: What are active transformation / Passive transformations?
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.
 
Is this answer useful? Yes | No
September 12, 2005 01:01:52   #2  
khadarbasha shaik        

RE: What are active transformation / Passive transformations?
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.
 
Is this answer useful? Yes | No
January 24, 2006 03:38:50   #3  
sithusithu Member Since: December 2005   Contribution: 161    

RE: What are active transformation / Passive transform...

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


 
Is this answer useful? Yes | No
August 09, 2006 07:07:40   #4  
premvijaykumar Member Since: August 2006   Contribution: 3    

RE: What are active transformation / Passive transform...

if number of source = target it is passive transformation

if we can update or delete records it is active transformation

cheers,

prem


 
Is this answer useful? Yes | No
April 02, 2007 05:29:44   #5  
sheetal choudhary        

RE: What are active transformation / Passive transform...

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


 
Is this answer useful? Yes | No
July 31, 2007 17:36:55   #6  
Prodyot Sarkar        

RE: What are active transformation / Passive transform...
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.

 
Is this answer useful? Yes | No
August 06, 2007 05:23:51   #7  
Siraj khan        

RE: What are active transformation / Passive transform...
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.

 
Is this answer useful? Yes | No
October 07, 2007 11:05:45   #8  
Fazululla_Shaik Member Since: October 2007   Contribution: 8    

RE: What are active transformation / Passive transform...

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


 
Is this answer useful? Yes | No
January 29, 2008 04:08:00   #9  
haribabu pulimi Member Since: January 2008   Contribution: 1    

RE: What are active transformation / Passive transformations?

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

 
Is this answer useful? Yes | No
March 18, 2008 12:18:47   #10  
ashok_psgmech Member Since: March 2008   Contribution: 1    

RE: What are active transformation / Passive transformations?

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.

 
Is this answer useful? Yes | No
  Page 1 of 2   « First    1    2    >     Last »  


 
Go To Top


 Sponsored Links



 
Sponsored Links

 
Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape