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
- 7498 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
How do you update the records with or without using update strategy?
What is meant by incremental aggregation?
Partition, what happens if the specified key range is shorter and longer
What is Cognos script editor?
Does an informatica transformation support only aggregate expressions?
What is mapping debugger?
What are the features of complex mapping?
What is a repository manager?
What is meant by lookup transformation? Explain the types of lookup transformation?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is a joiner transformation and why it is an active one?
How many numbers of sessions can one group in batches?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Write the different tools in the workflow manager?
How does the aggregator transformation handle null values?
