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.


August 08, 2006 07:07:40 #4
 premvijaykumar   Member Since: August 2006    Total Comments: 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

     

 

Back To Question