Interested to Buy Any Domain ? << Click Here >> for more details...
What is the main difference between a Joiner Transformation
and Union Transformation?
- 5 Answers
- 31890 Views
- I also Faced
- E-Mail Answers
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 are the various types of transformation?
design of staging area?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Describe expression transformation?
What do you understand by term role-playing dimension?
What is a surrogate key?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is meant by active and passive transformation?
What is union transformation in informatica?
What is persistent lookup cache?
Where is metadata stored?
explain one complex mapping with logic? sales project?
What if the source is a flat-file?
What do you understand by a term domain?
Explain lookup transformation is active in informatica
