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

Explain Dataware house architecture .how data flow from intial to end?

2343


In development project what is the process to follow for an etl developer from day1

1489


What is the different lookup cache(s)?

823


What are the designer tools for creating transformations?

894


What are some examples of informatica etl programs?

740


What is workflow? What are the components of workflow manager?

933


Can we override a native sql query within informatica?

830


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3626


What are the differences between joiner transformation and source qualifier transformation?

893


waht type of interface is used for testing the data in informatica

2011


What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2136


What is sq transformation?

858


How can one identify whether mapping is correct or not without connecting session?

1155


Design a mapping to load the cumulative sum of salaries of employees into target table?

1201


What are the advantages of informatica?

766