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
- 15611 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 |
Do you have to change the reject file b4 using reject loader utility.
What is primary and backup node?
how to return multiple columes through through un-connect lookup?
How might you approve all mappings in the archive all the while?
What is a grid in Informatica?
What are mapplets? How is it different from a Reusable Transformation?
split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar
1 Answers Cap Gemini, TCS, Wipro,
In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.
2 Answers Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,
Why do you use Mapping Parameter and mapping variable?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Explain lookup transformation is active in informatica
source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000
Teradata 
