Difference between Joiner and Union Transformation

Joiner:

• Using joiner we can remove duplicate rows
• Joiner can be Normal,Right Outer,Left Outer,Full Outer Join
• In Joiner we have one input group and one output group
• Joiner implemented by using Joiner Transformation in Informatica.
• Joiner Transformation combines data record horizontally based on a join condition

Union:

• Union will not remove duplicate rows
• Union is equlivalent to UNION ALL in SQL
• In Union we have multiple input groups and one output group.
• Union implemented by using Union Transformation in Informatica
• Union Transformation combines data record vertically from multiple sources
• Union also supports hetregenous(different sources)