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 are connected or unconnected transformations?
What are the issues you have faced in your project? How did you overcome those issues?
What are the restrictions of union transformation?
Write the unconnected lookup syntax and how to return more than one column.
What are the measure objects?
How an expression transformation differs from aggregator transformation?
4 yrs etl devloper roles and responsibilities?any body give solutions
What do you mean by filter transformation?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is status code in informatica?
Partition, what happens if the specified key range is shorter and longer
Explain about cumulative Sum or moving sum?
How many numbers of sessions can one group in batches?
