Transformations in Informatica are the repository OBJECTS that transform the source data according to the needs of the target system and ensure that the quality of loaded data is maintained. The following transformations are PROVIDED by Informatica to accomplish specific functionalities: 

• Aggregator TRANSFORMATION: An active transformation used to compute averages and sums (especially across multiple rows or groups).
• Expression transformation: A passive transformation suitable for calculating values in one ROW. In addition, conditional statements can be tested before they are written to target tables or other transformations.
• Filter transformation: An active transformation used for filtering rows in mappings that don't meet the given condition.
• Joiner transformation: An active transformation joins data from different sources or from the same location.
• Lookup transformation: In order to get relevant data, a lookup transformation looks up a source, source QUALIFIER, or target. Results of the lookup are returned to another transformation or the target object. Active Lookup transformation returns more than one row, whereas passive transformation returns only a single row.
• Normalizer transformation: An active transformation used for normalizing records sourced from Cobol sources whose data is usually in de-normalized format. A single row of data can be transformed into multiple rows using it.
• Rank transformation: An active transformation used to select top or bottom rankings.
• Router transformation: An active transformation provides multiple conditions for testing the source data.
• Sorter transformation: An active transformation sorts data according to a field in ascending or descending order. Additionally, to set case-sensitive sorting.
• Sequence Generator transformation: A passive transformation used to generate numeric values. Each record in the table is uniquely identified by creating unique primary keys or surrogate keys.
• Source Qualifier transformation: An active transformation reads rows from a flat-file or relational source while running a session and adds them to mapping. Using this tool, Source Data Types are transformed into Informatica Native Data Types
• Stored Procedure transformation: A passive transformation used to automate time-consuming processes or labor-intensive tasks. Additionally, used to handle errors, determine the database space, drop and recreate indexes, and perform specialized calculations.
• Update strategy transformation: An active transformation used to update data in a target table, either to maintain its history or incorporate recent updates.