|
JOINER
|
UNION
|
|
Using joiner we can remove duplicate
rows
|
Union will not remove duplicate rows
|
|
Joiner can be Normal,Right Outer,Left
Outer,Full Outer Join
|
Union is equlivalent to UNION ALL in SQL
|
|
In Joiner we have one input group and
one output group
|
In Union we have multiple input groups and one output group.
|
|
Joiner implemented by using Joiner
Transformation in Informatica.
|
Union implemented by using Union Transformation in Informatica
|
|
Joiner Transformation combines data
record horizontally based on a join condition
|
Union Transformation combines data record vertically from
multiple sources
|
|
Joiner supports both homegenousand
heterogenous
|
Union also supports hetregenous(different sources)
|
Monday 10 September 2012
Difference between Joiner and Union Transformation in Informatica
Subscribe to:
Post Comments (Atom)
Can u please explain how union combines data vertically?
ReplyDelete