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
Explain Dataware house architecture .how data flow from intial to end?
In development project what is the process to follow for an etl developer from day1
What is the different lookup cache(s)?
What are the designer tools for creating transformations?
What are some examples of informatica etl programs?
What is workflow? What are the components of workflow manager?
Can we override a native sql query within informatica?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What are the differences between joiner transformation and source qualifier transformation?
waht type of interface is used for testing the data in informatica
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 ?
What is sq transformation?
How can one identify whether mapping is correct or not without connecting session?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What are the advantages of informatica?