Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5 Answers
- 9031 Views
- Informatica, I also Faced
- E-Mail Answers
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
Explain the aggregator transformation?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is a pre-defined event and user-defined event?
Explain pmcmd command usage in informatica
What is rank transform?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Which version configuration tool used in ur project?
How do you change a non-reusable transformation to reusable transformation?
What is mapplet in informatica?
What is informatica metadata and where is it stored?
What is meant by LDAP users?
What is a filter transformation and why it is an active one?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is the use of target designer?
