Transformations

Rank Transformation helps in identifying largest or smallest set of values in a group of data by filtering the data and ranking the values.

A SQL Transformation can be used to process a SQL query either using a “Saved Query” or a User “Entered Query”.

SQL Transformation in Informatica Cloud is used to call a Stored Procedure or Function, or execute SQL queries midstream in a mapping pipeline.

Shared Sequences are reusable sequences that can be used with multiple Sequence Generator transformations in Informatica Cloud.

Joiner Transformation is used to join data coming from two different data streams based on the condition and the join type defined in Informatica Cloud

Normalizer Transformation transforms one incoming row that contains multiple-occurring data into multiple output rows in Informatica Cloud

Union Transformation in IICS is used to read data from multiple pipelines and merge data into a single pipeline.

Lookup transformation is used to look up a database table or a flat file based on a condition and retrieve value from the lookup.