By using aggregator t/r we can achieve. use || function

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 / amedela chandra sekhar

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

Answer Posted / amedela chandra sekhar

By using aggregator t/r we can achieve.
use || function

Is This Answer Correct ?

3 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the need for an etl tool?

1068

Implementation methodology

1714

What is different between the data warehouse and data mart?

1066

How to load the data from people soft hrm to people soft erm using informatica?

1020

Under which circumstances, informatica server creates reject files?

1095

What is session task and command task?

1298

What is fact table? Explain the different kinds of facts.

1077

Can we override a native sql query within informatica?

1038

How can we improve session performance in aggregator transformation?

1117

What are the different versions of informatica?

1275

How many transformations can be used in mapplets.

1935

What is a transaction control transformation?

1208

How to load the data from a flat file into the target where the source flat file name changes daily?

1063

what is the complex transformation you used in informatica

2588

Why update strategy and union transformations are active?

1042