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
What is the format of informatica objects in a repository?
Why filter transformation is an active one?
What is option by which we can run all the sessions in a batch simultaneously?
What is the need for an etl tool?
How to update a particular record in target with out running whole workflow?
How can we create index after completion of load process?
what is the hint? how to use it to reduce the query processing in program?
How do you update the records with or without using update strategy?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is the fact table?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What will be the approach?
How to generate sequence numbers without using the sequence generator transformation?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is meant by pre and post session shell command?