split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar
1 14682Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE
2 5736There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping
3 7635can we have to do changes in session property when we are dynamically generating target files?
3 7734If 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???
5 9827Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario
4 6088Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
1575Post New Wipro Informatica Interview Questions
Does each process scheduler server domain have its own location in the Report Repository?
What are sleeve and cotter joint?
Can we overload the main method in c#?
Explain Default cursor Type and LockEdits type in RDO?
Describe how you have gone about ensuring that high standards of service are delivered consistently
What is the use of isNaN function?
What does a search engine optimization campaign involve?
How can you make the connection using jdbc?
which pump used in STP
In wordpress, what do you mean by a child theme?
Can we create user defined functions in qtp?
What Happens In Memory When You Box And Unbox A Value-type?
What do you understand by spring?
Can I interrupt chkdsk?
Why we calculate supplier PPM (Part Per Million).WE can calculate Supplier performance in % also, why PPM ?