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
- 7074 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sarat
In EXP take
2 variable ports
name1 = substr(name,instr(name,'_',1,1)+1)
name2 = concat('_',substr(name,1,instr(name,'_',1,1)-1))
1 O/p port
result = concat(name1,name2)------> this is ur o/p
I wish it works, if any problem occurs,
take '_' as 3rd variable name3 and
concat(name3,name2)
concatenate the result with name 1
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sivaramakrishna
boss am not getting i have tried as u said
thank you
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
Answer / 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 |
Can you try reverse function in informatica....
| Is This Answer Correct ? | 0 Yes | 1 No |
there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source
How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?
What is dimensional table? Explain the different dimensions.
In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How to load the data from people soft hrm to people soft erm using informatica?
Can we make worklet inside worklet?
What is the target load order?
how do u get the first record from 50,000 records ?
10 Answers TCS, UBS,
what is filelist concept in informatica
What is different between the data warehouse and data mart?
Explain joiner transformation in informatica
Teradata 
