What is the main difference between a Joiner Transformation
and Union Transformation?
Answer Posted / raj
Join Transformation combines data record horizontally based on
join condition.
And combine data from two different sources having different metadata.
Join transformation supports heterogeneous, homogeneous data source.
Union Transformation combines data record vertically from multiple sources, having same metadata.
Union transformation also support heterogeneous data source.
Union transformation functions as UNION ALL set operator
Is This Answer Correct ? | 30 Yes | 2 No |
Post New Answer View All Answers
What is a repository manager?
can you please explain me pre session and post session options?
What are the differences between a connected lookup and unconnected lookup?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What are the new features of informatica 9.x at the developer level?
How to implement security measures using repository manager?
What are the new features of Power Center 5.0?
What is workflow manager?
Explain lookup transformation is active in informatica
How do you update the records with or without using update strategy?
What are the differences between joiner transformation and source qualifier transformation?
How to Create a folder using pmrep command?
How to create or import flat file definition in to the warehouse designer?
What is sequence generator transformation in informatica?
Explain sql transformation in script mode examples in informatica