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 |
Where do we use mapping variables in informatica?
How to prepared lld.can any one tell me detailed explanetion.
What does update strategy mean, and what are the different option of it?
in what type of scenario bulk loading and normal loading we use?
what is row level and column level indicator?
how many types transformations supported by sortedinput?
write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15
What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?
what is sql override?what is the use of it?
Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance
explain about informatica server architecture?
Where should yoU place the flat file to import the flat file defintion to the designer?