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
- 1 Answers
- 15792 Views
- Cap Gemini, TCS, Wipro, I also Faced
- E-Mail Answers
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 |
What is a stored procedure transformation?
what is surrogatekey ? In ur project in which situation u has used ? explain with example ?
How can we join the tables if they don't have primary and foreign key relationship and no matching port?
if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000
how i will stop my workflow after 10 errors
What is an aggregator transformation? it is active why cant it be passive explain?
What is the term PIPELINE in informatica ?
What aer the out put files that the informatica server creates during the session running?
What is the fact table?
Why update strategy and union transformations are active? Explain with examples.
what is the size of u r project? and what is the size of source file?
what is the main advantage of unconnected lookup
Teradata 
