| |
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, 2007 05:23:51 |
#7 |
| Siraj khan |
Member Since: Visitor Total Comments: N/A |
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. |
| |
Back To Question | |
