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
- 7267 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
Explain sessions?
What is repository manager?
What is the difference between Active and Passive transformation?
What are ETL Tools?
What are Dimensional table?
How can we improve session performance in aggregator transformation?
Explain pmcmd command usage in informatica
What is informatica powercenter repository?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Explain the different kinds of facts.
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is resilience time?
What is the status code in stored procedure transformation?
Informatica Checkpoints
While importing the relational source definition from the database, what are the metadata of source that will be imported?
