Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

How do you take back up of repository?

0 Answers  


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

0 Answers  


how to run workflow in unix?

5 Answers   Colgate, HP, Tech Mahindra,


Useful UNIX commands regular/frequently used

1 Answers   Deloitte,


we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks

3 Answers   TCS,


I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 Answers  


To achieve the session partition what r the necessary tasks u have to do?

1 Answers  


what r the propertes of workflow? and write quary to select dept more ten employess in dept.?

2 Answers  


source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000

7 Answers   Cap Gemini,


What is router transformation

4 Answers   CSC,


i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?

7 Answers   IBM, TCS,


how the server recognises , if the session fails after loading the 100 records in to the target

2 Answers   TCS,


Categories