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 deployment group?
Explain lookup transformation in informatica
What are pre and post-session shell commands?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is data movement mode in Informatica and difference between them?
What is parallel processing in informatica?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is a difference between complete, stop and abort?
What is a repository manager?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
How do you manage the Parameter files while migrating your data from one environment to another environment?
If informatica has its scheduler why using third party scheduler?
How do you promote a non-reusable transformation to reusable transformation?
Differentiate between Load Manager and DTM?
how to create user defined function (udf) in informatica