Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / mayank jhawar
Active Transformation -
An Active transformation can change teh number of rows that
pass through it from source to traget. It eliminates rows
that do not meet the condition in transformation.
Passive Transformation -A Passive transformation does not
change teh number of rows that pass through it i.e., it
passes all rows through the transformation.
List of transformations coming under Active transformations
are -
Source Qualifier Transformation
Aggregator Transformation
Filter Transformation
Rank Transformation
Joiner Transformation
Router Transformation
Normalizer Transformation
Update strategy Transformation
Sorter Transformation
ERP Source Qualifier Transformation
Advanced External Procedure Transformation
Look Up (now it is an active transformation)
And here find the Passive Transformations list -
Expression Transformation
Sequence Generatoe Transformation
LookUP Transformation (till Informatica Version9.0)
Stored Procedure Transformation
XML Source Qualifier Transformation
External procedure Transformation
Input Transformation(Mapplet)
Output Transformation(Mapplet)
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
what is INFORMATICA TESTING process
What are the types of presistent cache in look up tr.
What is the difference between a repository server and a powerhouse?
What is the benefit of session partitioning?
Explain constraint based loading in informatica
What's the layout of parameter file (what does a parameter file contain?)?
What if the source is a flat-file?
What is rank transformation?
What are the differences between oltp and olap?
How to convert multiple rows to single row (multiple columns) in informatica
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is rank transform?
How to update a particular record in target with out running whole workflow?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What are mapplets?
