SRC->SQ->SRT->AGG JNR TAR SRC->SQ->SRT->EXP->

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

Question Posted / santa

2 Answers
7395 Views
CTS, I also Faced
E-Mail Answers

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

Suppose we do not group by on any ports of the aggregator what will be the output?

1044

How can informatica be used for an organization?

1220

Explain sessions?

1071

What is the different lookup cache(s)?

1089

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1797

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

2107

What is data caches/ index caches?

1108

What is flashback table ? Advance thanks

1942

Differentiate between Load Manager and DTM?

2160

What is the difference between router and filter?

1273

Can you generate sequence numbers without using the sequence generator transformation?

1124

lookup transformation with screenshots

4006

What are the designer tools for creating transformations?

1119

What are the performance considerations when working with aggregator transformation?

1155

4 yrs etl devloper roles and responsibilities?any body give solutions

2171