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
- 6920 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain sessions. Explain how batches are used to combine executions?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Explain the etl program with few examples.
What is a pre-defined event and user-defined event?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is the command used to run a batch?
How to delete duplicate row using informatica?
What is the reusable transformation?
What are roles and groups and benefits of using them?
explan ur project architecture?
Different circumstance which drives informatica server to expel records?
what is the hint? how to use it to reduce the query processing in program?
How many transformations can be used in mapplets.
What is dimensional table?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
