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)
|
A blog where you can explore everything about Datawarehouse, OBIEE, Informatica, Power BI, QlikView, Hadoop, Oracle SQL-PLSQL, Cognos and much more....
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