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

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

Answer / 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 ?    25 Yes 0 No

Post New Answer

More Informatica Interview Questions

To provide support for Mainframes source data,which files r used as a COBOL files

1 Answers  

What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance

14 Answers   Deloitte,

in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address

0 Answers   Cognizant,

While importing the relational source defintion from database,what are the meta data of source U import?

1 Answers  

how to connect two or more table with single source qualifier?

4 Answers   IBM,

Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?

2 Answers   TCS,

how to import multiple flat files in to single target where there is no common column in the flat files

2 Answers   TCS,

Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj

2 Answers  

My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this

2 Answers  

what is parameter file?

1 Answers   Cap Gemini,

Whatis the difference between View and Materialized View ?

11 Answers   Syntel, Satyam,

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

3 Answers   Cap Gemini,