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
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is the Process to creating lookup transformation in informatica
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?
Why union transformation is an active transformation?
How many input parameters can exist in an unconnected lookup?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Describe an informatica powercenter?
What do you understand by a term domain?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What are connected or unconnected transformations?
In which transformation you cannot drag ports into it?
What are the settings that you use to configure the joiner transformation?
waht type of interface is used for testing the data in informatica
Write the program through which the records can be updated?
Mention few power centre client applications with their basic purpose?