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

What do mean by local and global repository?

0 Answers  


How can informatica be used for an organization?

0 Answers  


There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)

4 Answers  


Explain joiner transformation in informatica

0 Answers   Informatica,


ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?

3 Answers   HP,






can every transfomation reusable?how?

2 Answers   Wipro,


if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.

5 Answers   Wipro,


How the informatica server sorts the string values in Rank transformation?

1 Answers   Informatica,


how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.

1 Answers  


how many repositories can v create in informatica .

3 Answers   Cap Gemini, Tech Mahindra,


What is critical mapping?

2 Answers  


How to call shell scripts from informatica?

0 Answers  


Categories