What is the main difference between a Joiner Transformation
and Union Transformation?
- 5 Answers
- 30523 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
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is meant by a domain?
In which transformation you cannot drag ports into it?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How is union transformation utilized?
Define the various join types of joiner transformation?
what is the -ve test case in your project.
Which transformation is needed while using the Cobol sources as source definitions?
4 yrs etl devloper roles and responsibilities?any body give solutions
What do you understand by SOA of Informatica?
During the running session, output files are created by informatica server. Enlist few of them.
Explain what are the different types of transformation available in informatica.
Can we change Dynamic to Static or Persistent cache? If so what happens?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What are the components of Informatica? And what is the purpose of each?
