Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 7393 Views
- CTS, I also Faced
- E-Mail Answers
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
Plz can any one say me how to get the informatica certification materials and dumps
How many ways are there to create ports?
Where are the source flat files kept before running the session?
Briefly explain the aggregator transformation?
What is decode in informatica?
my source is junk data how will u remove that junk data by using unix please any one replay me
What is the function of look up transformation?
How to convert multiple rows to single row (multiple columns) in informatica
How will the document be delivered to me?
How are the sources and targets definitions imported in informatica designer?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Explain the pipeline partition with real time example?
Can we change Dynamic to Static or Persistent cache? If so what happens?
COM components can be used in Informatica
What is union transformation?
