split two strings into two columns
For Eg.
Source:-Full Name: Shiva Kumar
Target:-
First Name:Shiva
Last Name:Kumar
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 |
How do you take back up of repository?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
how to run workflow in unix?
5 Answers Colgate, HP, Tech Mahindra,
Useful UNIX commands regular/frequently used
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
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?
To achieve the session partition what r the necessary tasks u have to do?
what r the propertes of workflow? and write quary to select dept more ten employess in dept.?
source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000
What is router transformation
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?
how the server recognises , if the session fails after loading the 100 records in to the target