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

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

Please Help Members By Posting Answers For Below Questions

What are the advantages of using informatica as an etl tool over teradata?

1027

What are the new features of Power Center 5.0?

1784

Design time, run time. If you don't create parameter what will happen

1838

What is difference between a gateway node and worker node?

1145

What is joiner transformation in informatica?

1048

What are the tuning techniques you applied during your last project

2029

Explain joiner transformation in informatica

1131

What is an unconnected transformation?

1090

How to generate or load values in to the target table based on a column value using informatica etl tool.

1081

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1061

How can you validate all mappings in the repository simultaneously?

1376

Explain the different kinds of facts.

987

What is informatica etl tool?

1003

What is the benefit of session partitioning?

1116

What is Session and Batches?

1111