Please create a mapping where I have source which has one column with name like Aman_Gupta
Rakesh_Mehra
Sachin_More
I want the target field should contain the name in reverse order i.e Gupta_Aman
Mehra_Rakesh
More_Sachin.

Can you please tell me what transformation would be needed to do this.

Answer Posted / bhagwati

reverse function will return the character string after reversing it.
For e.g. reverse(Aman_Gupta) will return atpuG_namA

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1359


Describe an informatica powercenter?

817


Explain the difference between mapping parameter and mapping variable?

814


What is the use of transformation?

775


how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1475


Why do you use Mapping Parameter and mapping variable?

1487


What are the informatica performance improvement tips

831


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1798


What are the different versions of informatica?

958


Explain the use of aggregator cache file?

939


Explain sessions?

779


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

4512


What is informatica etl tool?

754


What are the advantages of using informatica as an etl tool over teradata?

788


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?

776