Aggregator with group by on column with values 1, 2, 3

I HAVE A SOURCE FILE CONTAINING
1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B
AND IN TARGET I SHOULD GET LIKE
1|A+B+C+D
2|A+B
3|A+B
WHICH TRANSFORMATION I SHOULD USE

Question Posted / guest

5 Answers
8983 Views
Informatica, I also Faced
E-Mail Answers

Answer Posted / guest

Aggregator with group by on column with values 1, 2, 3

Is This Answer Correct ?

7 Yes

12 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

can you please explain me pre session and post session options?

7391

How to elaborate powercenter integration service?

1071

wf dont have integration severances how you can run?

1880

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2179

How might one distinguish in the case of mapping is right or not without associating session?

1017

What is aggregator transformation in informatica?

894

What is the reusable transformation?

1005

What do you mean by blocking transformation?

966

What are the steps involved in the migration from older version to newer version of Informatica Server?

2039

How can a transformation be made reusable?

1076

what is the size of u r source(like file or table)?

2196

How can we create index after completion of load process?

1068

Define the various join types of joiner transformation?

940

What are the different types of transformation available in informatica.

1028

Why sorter is an active transformation?

1124