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.