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

Post New Answer




More Informatica Interview Questions

write a query for how to eliminate the duplicate rows without using distinct?

6 Answers   iGate,


difference between shortcut and reusable transformation?

2 Answers  


Mapplets can you use an active transformation in a mapplet,

1 Answers  


What are the methods for creating reusable transforamtions?

2 Answers  


what is service oriented architecture in Informatica 8 version

1 Answers   TCS, IBM, Cap Gemini, Systech,






I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.

4 Answers   IBM, Cap Gemini,


How to do Integration testing in Informatica?

5 Answers   Intelligroup,


Insert else update option in which situation we will use

4 Answers   HCL,


how can one eliminate dupliacte data with out using distinct option?

5 Answers   Patni, Wipro,


I still need further explanation about the difference between active and passive transformation with some examples.Thank You

5 Answers  


yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?

2 Answers   iGate,


how can i invoke pmcmd in command line prompt

1 Answers  






Categories