split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar
1 15801Source 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 6773There 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 9125can we have to do changes in session property when we are dynamically generating target files?
3 9139If 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 11790Scenario 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 7862Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
2057Post New Wipro Informatica Interview Questions
What are the default configuration files that are used in hadoop?
What is a document header? : fi- general ledger
What is the use of temperature compensation?
What is ORM ? Advantages of ORM ?
What are the different web fonts formats in css3?
from where do u collect test data if u miss some data what will happen
Explain PDL with an example?
What is the maximum limit?
If income and expense both are equal then what it depicts
Difference between $message vs. $$Message in php.
How do I access C style strings?
What is cakephp?
Explain the different steps of Commissioning.
Explain the jdbc abstraction and dao module
What is a python constant?