| |
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. |
| January 01, 2008 04:08:00 |
#9 |
| haribabu pulimi |
SQL Server Expert Member Since: January 2008 Total Comments: 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
|
| |
Back To Question | |
