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
- 7083 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
What does cheating measurement mean?
what is song in infrmatica...?
Explain the informatica workflow?
What are the different transaction levels available in transaction control transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
How to generate sequence numbers without using the sequence generator transformation?
tell me about your project functionality
Explain the different dimensions.
What do you understand by a term domain?
4 yrs etl devloper roles and responsibilities?any body give solutions
What is a joiner transformation?
What are the features of complex mapping?
What is powercenter on grid?
How to join three sources using joiner? Explain though mapping flow.
