output1=substr(name,1,instr(name,' ')-1) output2=substr(name,ins

split two strings into two columns
For Eg.
Source:-Full Name: Shiva Kumar
Target:-
First Name:Shiva
Last Name:Kumar

Question Posted / venky

1 Answers
15791 Views
Cap Gemini, TCS, Wipro, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What is the meaning of decode in informatica?

1164

Mention few advantages of router transformation over filter transformation.

1067

What is the procedure for creating independent data marts from informatica 7.1?

1115

What does reusable transformation mean?

1192

What is source qualifier transformation in informatica?

1062

Tell me about MD5 functions in informatica

979

Differentiate between a database and data warehouse?

1187

What is a sorter transformation?

1153

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?

1058

Explain load alternative records / rows into multiple targets - informatica

1202

What happens when a session fails and you click on recover?

1170

How are indexes created after completing the load process?

1716

What is an unconnected transformation?

1128

How to load the data from a flat file into the target where the source flat file name changes daily?

1096

What is informatica? Why do we need it?

1162