Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 5 Answers
- 7147 Views
- I also Faced
- E-Mail Answers
Answer Posted / shankarmba07@gmail.coom
In eXP transformation create 3 ports like:
name1:select substr(name,1,instr(name,'_',1,1)-1)
name2:select substr(name,instr(name,'_',1,1)+1)
O_Name:name2||'_'||name1)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Did u used latest transformations of 8.6.0? for what?
Separate from an archive server and a powerhouse?
Global and Local shortcuts. Advantages.
Have you worked with/created Parameter file
What are the limitations of joiner transformation?
What's the layout of parameter file (what does a parameter file contain?)?
What are the measure objects?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is update strategy transform?
What is a node in Informatica?
what is SDLC way of code development?
What do you mean by blocking transformation?
What is a repository manager?
what is the Default Source Option For Update Strategy Transformation?
have u done any performance tuning? how u ll do?
