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 / ankit kansal

There is only one row as per the defined problem. so first you have to break down this one row into multiple rows as separated by delimiter ','.
1|A
1|B
1|C
1|D
2|A...
Now in Expression Transformation using some string functions and later using rank/aggregator T/S you can achieve your result...

http://deepinopensource.blogspot.in

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

949


What is the Process to creating lookup transformation in informatica

832


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

800


Why union transformation is an active transformation?

874


How many input parameters can exist in an unconnected lookup?

1332


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

1880


Describe an informatica powercenter?

833


What do you understand by a term domain?

899


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1721


What are connected or unconnected transformations?

895


In which transformation you cannot drag ports into it?

1076


What are the settings that you use to configure the joiner transformation?

853


waht type of interface is used for testing the data in informatica

2050


Write the program through which the records can be updated?

788


Mention few power centre client applications with their basic purpose?

755