Which transformation is used to combine data from different sources?

What is Joiner transformation?

The Joiner transformation joins data based on the join conditions and the join type. A join condition matches fields between the two sources. You can create multiple join conditions. A join type defines the set of data that is included in the results.

What is difference between union and joiner transformation?

A Union transformation can merge data from multiple sources but does not combine data based on a join condition or remove duplicate rows, like a Joiner transformation. ... Comparison to Joiner transformation.RequirementUnion transformationJoiner transformationGenerate transactionsNoYes

What is active and passive transformation in Informatica?

An active transformation can change the number of rows that pass through the transformation. For example, the Filter transformation is active because it removes rows that do not meet the filter condition. A passive transformation does not change the number of rows that pass through the transformation.

What are the different transformation in Informatica?

There are 3 Informatica transformations viz. External Procedure, Lookup, and Stored Procedure which can be unconnected in a valid mapping (A mapping which the Integration Service can execute).