split two strings into two columns
For Eg.
Source:-Full Name: Shiva Kumar
Target:-
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 ?    26 Yes 1 No

Post New Answer

More Informatica Interview Questions

Where do we use mapping variables in informatica?

0 Answers  


How to prepared lld.can any one tell me detailed explanetion.

0 Answers   Bank Of America,


What does update strategy mean, and what are the different option of it?

0 Answers  


in what type of scenario bulk loading and normal loading we use?

2 Answers   Cognizant, Wipro,


what is row level and column level indicator?

1 Answers   TCS,






how many types transformations supported by sortedinput?

4 Answers  


write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15

5 Answers   Tech Mahindra,


What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?

3 Answers   Logica CMG,


what is sql override?what is the use of it?

4 Answers   Sonata,


Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance

2 Answers  


explain about informatica server architecture?

1 Answers   IBM,


Where should yoU place the flat file to import the flat file defintion to the designer?

4 Answers  


Categories