Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

translate function of oracle, equivalent function in informatica?

Mac_Freak_RahulAug 10 2011 — edited Aug 10 2011
Hi All,

I know its off topic but i am stuck very very badly and this place turns out to be he best for my issues, here is my problem:

lets say i hve fname coming from a flatfile and the first name is 'rahul' , it should be translated as '12345' usin informatica function, now lets say the 2nd name comes which is 'rohit' it should be translated as '1o3it'. I hope my problem is clear, please help me out.

Regards
Rahul Kalra

Edited by: Mac_Freak_Rahul on Aug 10, 2011 3:18 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 7 2011
Added on Aug 10 2011
4 comments
1,242 views