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
Answer Posted / santa
SRC->SQ->SRT->AGG
JNR TAR
SRC->SQ->SRT->EXP->
AGG INPUT/OUPUT-> ID
AGG VARIABLE/OUTPUT->COUNT(ID)
JNR COND:- ID1=ID
Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is mapping debugger?
How do you load alternate records into different tables through mapping flow?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is Cognos script editor?
Under what condition selecting sorted input in aggregator may fail the session?
What is DR strategy for Informatica project?
Mention few advantages of router transformation over filter transformation.
Sequence generator, when you move from develoment to production how will you reset
How can we improve session performance in aggregator transformation?
What is a joiner transformation?
What is confirmed fact in dataware housing?
What are the types of caches in lookup?
How to start a workflow using pmcmd command?
generate date / time dimension in informatica
What is joiner transformation in informatica?