Informatica PowerCenter: Supported transformation details

February 27, 2026

The following table shows a non-exhaustive list of supported and unsupported transformations in Informatica PowerCenter.

Supported transformations	Unsupported transformations
Aggregator Expression¹ Filter Input Joiner Lookup Mapplet² Normalizer Output Pre- and post-session SQL commands Rank Router Sorter Source SQL in the `translate_db_type` function Target Transaction Control Union Update Strategy	Data Masking Java Sequence Generator Stored Procedure³ Web Services XML
Note The transformation is shown if the column (expression) is using at least one column from another connected transformation. Collibra Data Lineage supports input transformations in mapplets but does not support source definitions in mapplets. The stored procedures are stored and run in the databases that Informatica PowerCenter connects to. Collibra Data Lineage does not access the Informatica PowerCenter data sources, so Collibra Data Lineage collects the stored procedure names but does not support the Stored Procedure transformation.

Supported transformations

Unsupported transformations

Note

The transformation is shown if the column (expression) is using at least one column from another connected transformation.
Collibra Data Lineage supports input transformations in mapplets but does not support source definitions in mapplets.
The stored procedures are stored and run in the databases that Informatica PowerCenter connects to. Collibra Data Lineage does not access the Informatica PowerCenter data sources, so Collibra Data Lineage collects the stored procedure names but does not support the Stored Procedure transformation.