split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar
1 15728Source 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 6684There 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 9038can we have to do changes in session property when we are dynamically generating target files?
3 9036If 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 11650Scenario 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 7710Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
2017Post New Wipro Informatica Interview Questions
Convert -40of into centigrade?
What is f:convertnumber tag in jsf (javaserver faces)?
The persied meteor showers are viewed in the state of maine during what month?
Is excel a software?
Define a java class.
Is mvc a layered architecture?
How will you deploy the dll file in gac?
How does Cassandra perform write function?
In Map Reduce why map write output to Local Disk instead of HDFS?
interest paid to bank rs.15000 in conection with statutory income tax proceedings.
What is super thermal power plant? and how it will differ from normal thermal power plant
To become an Instrument DESIGN engineer, is there any softwares or training to become Instrument Design engineer, plz suggest me, Iam very much interested in designing.
Explain me what is your understanding of medical terminology? : insurance health
What is pure virtual function?
Where is pl sql used?