split two strings into two columns
For Eg.
Source:-Full Name: Shiva Kumar
Target:-
First Name:Shiva
Last Name:Kumar
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 |
When you move from devel to prod how will you retain a variable
my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4
can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?
1 Answers Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,
How can we get multiple output values using an unconnected lookup transformation?
What are the different types of repositories created using informatica?
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance
1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),
write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?
What are the circumstances that infromatica server results an unreciverable session?
What if the source is a flat-file? Then how can we remove the duplicates from flat file source?