What is the main difference between a Joiner Transformation
and Union Transformation?
- 5 Answers
- 30525 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
Why do we need informatica?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What are the different ways to implement parallel processing in informatica?
What are the features of complex mapping?
Write the advantages of partitioning a session?
update strategy transformation in informatica
What is lookup change?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
How you know when to use a static cache and dynamic cache in lookup transformation?
What do you mean by channel change?
What do you mean by blocking transformation?
What is option by which we can run all the sessions in a batch simultaneously?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
can u give example for factless fact table
How to extract sap data using informatica? What is abap? What are idocs?
