Interested to Buy Any Domain ? << Click Here >> for more details...
What is the main difference between a Joiner Transformation
and Union Transformation?
- 5 Answers
- 31883 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
What is informatica etl tool?
What is rank transform?
What are the conditions needed to improve the performance of informatica aggregator transformation?
How to generate sequence numbers using expression transformation?
What is a joiner transformation?
Explian the Process of deployment groups in informatica
Suppose we do not group by on any ports of the aggregator what will be the output?
How many ways a relational source definition can be updated and what are they?
What is union transformation?
Can informatica load heterogeneous targets from heterogeneous sources?
Describe data concatenation?
What is an expression transformation in informatica?
Define pmcmd command?
State the differences between sql override and lookup override?
What is aggregator transformation in informatica?
