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
- 6974 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 |
How can you generate reports in informatica?
Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
what r the values tht r passed between informatics server and stored procedure?
what is target load plan
what is a transforamation?
How to list Top 10 salary, without using Rank Transmission?
To achieve the session partition what r the necessary tasks u have to do?
How to do Integration testing in Informatica?
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Differentiate between reusable transformation and mapplet.
Teradata 
