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

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

1669


What are the different transaction levels available in transaction control transformation?

673


What is the difference between Active and Passive transformation?

631


In which transformation you cannot drag ports into it?

776


What does reusable transformation mean?

672






Explain joiner transformation in informatica

666


How to load data in informatica ?

569


What is primary and backup node?

694


How to partition the Session?

643


Define enterprise data warehousing?

634


What is a dimensional model?

583


What is the Process to creating lookup transformation in informatica

583


How do you promote a non-reusable transformation to reusable transformation?

658


What are some examples of informatica etl programs?

533


What is a passive transformation?

638