Interested to Buy Any Domain ? << Click Here >> for more details...
What is the main difference between a Joiner Transformation
and Union Transformation?
- 5 Answers
- 32135 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 is meant by lookup transformation? Explain the types of lookup transformation?
How to load a Dimension ? and how to load a fact table?
Define pmcmd command?
Explain the types of lookup transformation?
Define the various join types of joiner transformation?
Clarify the utilization of aggregator cache record?
What is sq transformation?
how we can load rejected record's at run time?(not through bad files)
How do you load alternate records into different tables through mapping flow?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is a stored procedure transformation?
What are the different types of repositories created using informatica?
is it possible to index the data in cache of lkp transformation ?
Explain sessions?
How to elaborate powercenter integration service?
