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
Explian the Process of deployment groups in informatica
What is the use of code page?
How to create or import flat file definition in to the warehouse designer?
Explain the difference between a data warehouse and a data mart?
what is index?how it can work in informatica
What is a difference between complete, stop and abort?
What is different between the data warehouse and data mart?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Why update strategy and union transformations are active? Explain with examples.
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is native users?
What are the informatica performance improvement tips
What are roles and groups and benefits of using them?
What is a rank transform?
How many transformations can be used in mapplets.