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
- 6980 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 are the static cache and dynamic cache in informatica?
What is sorter transformation?
What is an expression transformation in informatica?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
what is the size of u r source(like file or table)?
How to handle decimal places while importing a flatfile into informatica?
What are multi-group transformations?
How do you load only null records into target? Explain through mapping flow.
What is meant by pre and post session shell command?
Write the prerequisite tasks to achieve the session partition?
How to convert multiple rows to single row (multiple columns) in informatica
How does a sorter cache works?
What differs when we choose the sorted input for aggregator transformation?
What do mean by local and global repository?
Briefly describe lookup transformation?
