split two strings into two columns
For Eg.
Source:-Full Name: Shiva Kumar
Target:-
First Name:Shiva
Last Name:Kumar
Answer Posted / venky
output1=substr(name,1,instr(name,' ')-1)
output2=substr(name,instr(name,' ')+1)
output1 means firstname
output2 means last name
| Is This Answer Correct ? | 26 Yes | 1 No |
Post New Answer View All Answers
What is the meaning of decode in informatica?
Mention few advantages of router transformation over filter transformation.
What is the procedure for creating independent data marts from informatica 7.1?
What does reusable transformation mean?
What is source qualifier transformation in informatica?
Tell me about MD5 functions in informatica
Differentiate between a database and data warehouse?
What is a sorter transformation?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Explain load alternative records / rows into multiple targets - informatica
What happens when a session fails and you click on recover?
How are indexes created after completing the load process?
What is an unconnected transformation?
How to load the data from a flat file into the target where the source flat file name changes daily?
What is informatica? Why do we need it?