What is the main difference between a Joiner Transformation
and Union Transformation?
Answer Posted / yaseen
we can create multiple input groups,but only one
out put group
Union Transformation combines data record vertically from multiple sources, having same metadata.
The structure and Data types should be same while using Union transformation
Join Transformation combines data record horizontally based on
join condition.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
State the differences between sql override and lookup override?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What are the types of presistent cache in look up tr.
Is there any target staging area in informatica not staging area
can we override a native sql query within informatica? Where do we do it?
What are the differences between oltp and olap?
Explain the informatica workflow?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How do you promote a non-reusable transformation to reusable transformation?
What is flashback table ? Advance thanks
Explain transaction control transformation in informatica
What is lookup change?
What is meant by a domain?
How to convert multiple rows to single row (multiple columns) in informatica
What are pre and post-session shell commands?