Input flatfile1 has 5 columns, faltfile2 has 3 columns(no
common column)
output should contain merged data(8 columns)
Please let me know how to achieve ??
Answer Posted / moorthy g
You Can create dummy port for each source Qual. then connect
to Join Trans., and Join two dummy port.in Joiner
Transformation.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is repository manager?
can anyone explain me about retail domain project in informatica?
what are 3 tech challenges/ common issues you face?
What is workflow monitor?
How do you handle two sessions in Informatica
What is sq transformation?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Clarify the aggregator change?
Can anyone tell me the new features in Informatica 9 Version?
What is target designer and target load order?
Explain what are the different versions of informatica?
Explain the types of transformations?
What is intricate mapping?