split two strings into two columns
For Eg.
Source:-Full Name: Shiva Kumar
Target:-
First Name:Shiva
Last Name:Kumar
- 1 Answers
- 15254 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 |
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)
How can yoU create or import flat file definition in to the warehouse designer?
How to improve the session performance in informatica?
How can informatica be used for an organization?
Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?
If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???
scenario where i can use only concurrent execution of workflow.
How to display First letter of Names in Caps?
replace multiple spaces with single space.
Is it possible to use a client with different version than that of its Informatica server?
what are the differences between powercenter 8.1 and powercenter 8.5?
Teradata 
