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
- 6927 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 databases that informatica can connect to windows?
how to create user defined function (udf) in informatica
How to create a non-reusable instance of reusable transformations?
What is a grid in Informatica?
What is different between the data warehouse and data mart?
How many types of sessions are there in informatica.please explain them?
How to do unit testing in informatica? How to load data in informatica ?
What is a snowflake schema?
What is powercenter on grid?
can we override a native sql query within informatica? Where do we do it?
In informatics server which files are created during the session rums?
What are junk dimensions?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is dimensional table?
complex mapping ur project u r invlve can u explain and give real time example give me ?
