Question: what is the difference between union and joiner transformation in informatica?
Answer: 2. The Joiner Transformation supports Normal,Right Outer, Left Outer, and Full Outer JOINs. You cannot combine records based on a join condition in Union Transformation. The Union Transformation is equivalent to a UNION ALL statement in SQL, which combines data vertically from multiple sources.