Interested to Buy Any Domain ? << Click Here >> for more details...
What is the main difference between a Joiner Transformation
and Union Transformation?
- 5 Answers
- 32054 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
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Explain joiner transformation in informatica
How to load a Dimension ? and how to load a fact table?
difference between informatica 8.1.1 and 8.6
Informatica settings are available in which file?
What is a mapplet/worklet in informatica?
Briefly define reusable transformation?
How is union transformation utilized?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Enterprise data warehouse your projects phase by phase explain?
Explain the pipeline partition with real time example?
What are the new features of informatica 9.x at the developer level?
What is a snowflake schema?
What is workflow? What are the components of workflow manager?
What do you mean by channel change?
