What is the main difference between a Joiner Transformation
and Union Transformation?
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 does cheating measurement mean?
What is an active transformation?
What is an expression transformation?
design of staging area?
Which are the different editions of informatica powercenter that are available?
What are the reusable transformations?
Explain how to import oracle sequence into informatica?
can u give example for factless fact table
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
How might you approve all mappings in the archive all the while?
How do we call shell scripts from informatica?
What is status code in informatica?
What is the procedure for creating independent data marts from informatica 7.1?
What are the different ways to implement parallel processing in informatica?
State the differences between sql override and lookup override?