Informatica- List of Transformations

The following are the list of Transformations:

Advanced External Procedure -It supports only informatica procedures
Aggregator – to do things like “group by”.
ERP Source Qualifier -Extracts data from ERP
Expression – to use various expressions.
External procedure – …It supports both Informatica and external procedure(UNIX)
Filter – to filter data.
Joiner – to make joins between separate databases, file, ODBC sources.
Lookup – to create local copy of the data.
Normalizer – to transform denormalized data into normalized data.
Rank – to select only top (or bottom) ranked data.
Sequence Generator – to generate unique IDs for target tables.
Source Qualifier – to filter sources (SQL, select distinct, join, etc.)
Update Strategy – to flag records in target for insert,delete, update (defined inside a mapping).
SQL Transformation– We can pass database connection information as input
Transaction Control Transformation– It lets user to control Commit/Rollback
Stored Procedure Transformation– Stored procedures store and run in the database. It returns value.
Java Transformation-It allows to import user defined function, written in Java, to run in informatica
Sorter Transformation: It supports to sort the data
Union Transformation: It supports to join the rows

Other transformations:

Srinimf