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 / babu
Hi Frnds,
by using aggregator we can achieve this,the mapping is have
two pipelines which is shown like bellow.
Mapping:
=======
SRC==>SQ==>EXP==>AGGR==>JNR==>TRG
|| ||
EXP1=========>
AGGR: GROUP BY ALL PORTS AND OUPUT PORT IS REPEAT=COUNT(ID)
JNR:JOIN THE TWO PIPELINES BY USING ID FROM AGGR AND EXP1 .
AGGR:
ID NAME REPEAT(OUTPUT PORT)
1 X 2
2 Y 2
JNR:ID=ID
OUTPUT OF THE JOINER IS
ID NAME REPEAT
1 X 2
1 X 2
2 Y 2
2 Y 2
TRG:
ID NAME REPEAT
1 X 2
1 X 2
2 Y 2
2 Y 2
Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
How does a rank transform differ from aggregator transform functions max and min?
What is rank transformation in informatica
What are the new features of informatica 9.x developer?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is the difference between stop and abort in informatica
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How many number of sessions can one group in batches?
How to create the source and target database connections in server manager?
Explain the different kinds of facts.
In warehouses how many schemas are there?
What are the different components of powercenter?
Why do you use Mapping Parameter and mapping variable?
What is the difference between router and filter?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
what is informatica metadata?