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
Explain load alternative records / rows into multiple targets - informatica
What is the function of look up transformation?
What are batches?
What are the different versions of informatica?
What is lookup transformation?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is joiner transformation?
How does the aggregator transformation handle null values?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is a router transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is sorter transformation?
What does reusable transformation mean?
During the running session, output files are created by informatica server. Enlist few of them.