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


Please Help Members By Posting Answers For Below Questions

What is mapping debugger?

778


How do you load alternate records into different tables through mapping flow?

1612


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

916


What is Cognos script editor?

3984


Under what condition selecting sorted input in aggregator may fail the session?

900


What is DR strategy for Informatica project?

938


Mention few advantages of router transformation over filter transformation.

865


Sequence generator, when you move from develoment to production how will you reset

1687


How can we improve session performance in aggregator transformation?

912


What is a joiner transformation?

782


What is confirmed fact in dataware housing?

6283


What are the types of caches in lookup?

802


How to start a workflow using pmcmd command?

963


generate date / time dimension in informatica

922


What is joiner transformation in informatica?

866