| |
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. |
| April 04, 2007 05:29:44 |
#5 |
| sheetal choudhary |
Member Since: Visitor Total Comments: N/A |
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 |
| |
Back To Question | |
