split two strings into two columns
For Eg.
Source:-Full Name: Shiva Kumar
Target:-
First Name:Shiva
Last Name:Kumar
Answer Posted / 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 View All Answers
What is a sequence generator transformation?
Explain Dataware house architecture .how data flow from intial to end?
Describe expression transformation?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
How can we improve session performance in aggregator transformation?
What is complex mapping?
What do mean by local and global repository?
What are mapplets? How is it different from a Reusable Transformation?
What does cheating measurement mean?
What is the use of code page?
What differs when we choose the sorted input for aggregator transformation?
How does a sorter cache works?
What is the difference between a connected look up and unconnected lookup?
Can you use flat files in Mapplets.
explain one complex mapping with logic? sales project?