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
- 8995 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
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What do you understand by SOA of Informatica?
What is meant by incremental aggregation?
What is a dimensional model?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Define Pmrep command?
What are the different types of repositories created using informatica?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How to join three sources using joiner?
What is status code in informatica?
Explain sessions. Explain how batches are used to combine executions?
Explain lookup transformation is active in informatica
How do we call shell scripts from informatica?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
