Interested to Buy Any Domain ? << Click Here >> for more details...
What is the main difference between a Joiner Transformation
and Union Transformation?
- 5 Answers
- 32137 Views
- I also Faced
- E-Mail Answers
Answer Posted / medatati satya teja ravi kiran
UNION:1)we can create multiple input groups,but only one
out put group
2)we can connect heterogeneous sources to a union
transformation
3)The union tf does not remove duplicate rows.To remove
duplicte rows, we must add another tf such as router or
filter tf
JOIN:1)Used to join source data from two related
hetorogeneous sources residing in different locations or we
can join data from the same source
2)The joiner tf remove duplicate rows...
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
How do you load alternate records into different tables through mapping flow?
What is the session task and command task?
What is an expression transformation?
What are the different clients of powercenter?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
How to do unit testing in informatica? How to load data in informatica ?
How do you update the records with or without using update strategy?
What are multi-group transformations?
What is informatica etl tool?
Differentiate between source qualifier and filter transformation?
What could be the possible resons of locks by user?
Is it possible to revert a global repository to local one and why?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How do you take back up of repository?
