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
How to update a particular record in target with out running whole workflow?
What is informatica? Why do we need it?
How can you differentiate between powercenter and power map?
What is a standalone command task?
How do you load unique records into one target table and duplicate records into a different target table?
What is a difference between complete, stop and abort?
Tell me about Propagate functions in informatica
what is the hint? how to use it to reduce the query processing in program?
Make a note of the quantity vaults made in informatica?
what is the Default Source Option For Update Strategy Transformation?
How do we call shell scripts from informatica?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
How to go to the older version for a mapping?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Can we create multiple integration service on single repository?