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
- 15718 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 are testing in a mapping level please give brif eplanation
Design a mapping to load a target table with the following values from the above source?
What is a filter transformation and why it is an active one?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
wat are deployement groups in informatica, how it will be used for developers
What if the source is a flat-file?
What is InformaticaPowerCenter?
i did MBA in 2008. i got job as a Software Engineer(Informatica) in 2008 February in our college campus interviews through consultancy. my problem is when iam going interview HR people ask " YOu are MBA graduate how u get software(informatica) job". iam saying i got job in campus interviews. i have knowledge in informatica in dataware housing. is this answer correct or not. plese give me guidence
explan ur project architecture?
my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?
what are the row and column separations in Flat Files
Why we require dwh in particular projects?
Teradata 
