split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar
1 15724Source 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 6679There 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 9027can we have to do changes in session property when we are dynamically generating target files?
3 9029If 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 11637Scenario 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 7703Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
2013Post New Wipro Informatica Interview Questions
Can you have a negative z index?
How does yield work in scala?
Which are the main coalition groups in the agriculture negotiations?
What are the best python libraries used in machine learning?
What does ios stand for apple?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
What do you understand by integration services in sql server?
How much river sand contain the 6 & 10 wheeler truck? Or Maximum sand that any type of truck carry?
What is metric store database?
Why use in ht motore
how can you pass values to-and-fro from foreign function?
What to do if windows is not starting?
What are the permission sets in salesforce?
Define the necessity of run stats among the environment test?
What is mixins in css?