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

 Print  |  
Question:  What are active transformation / Passive transformations?

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


October 10, 2007 11:05:45 #8
 Fazululla_Shaik   Member Since: October 2007    Total Comments: 1 

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

     

 

Back To Question