Informatica Top 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, files, ODBC sources.
Lookup – to create a 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 control Commit/Rollback
Stored Procedure Transformation– Stored procedures store and run in the database. It returns a value.
Java Transformation-It allows importing 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