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

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

How to update a particular record in target with out running whole workflow?

1386


What is informatica? Why do we need it?

889


How can you differentiate between powercenter and power map?

876


What is a standalone command task?

939


How do you load unique records into one target table and duplicate records into a different target table?

987


What is a difference between complete, stop and abort?

877


Tell me about Propagate functions in informatica

738


what is the hint? how to use it to reduce the query processing in program?

7204


Make a note of the quantity vaults made in informatica?

802


what is the Default Source Option For Update Strategy Transformation?

1013


How do we call shell scripts from informatica?

815


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2160


How to go to the older version for a mapping?

842


what are the different types of transformation available in informatica. And what are the mostly used ones among them?

753


Can we create multiple integration service on single repository?

983