split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar
1 15718Source 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 6676There 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 9021can we have to do changes in session property when we are dynamically generating target files?
3 9023If 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 11629Scenario 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 7697Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
2012Post New Wipro Informatica Interview Questions
hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...
What is hashmap and map?
How to managed create a table in hive ?
what is the use of State Factories?
What is a filter transformation and why it is an active one?
Explain the application life cycle of yii framework ?
How do I merge word documents without losing formatting?
10 users entering the data in infopath forms and submit the data, now i want to generate the reports for those 10 users, how can you do this?
Which is the research reactors of bhabha atomic research centre?
How can we create a database using php?
When would you use var in your declaration and when you wouldn’t?
What are the different types of springs and explain them?
How to update values in a table in oracle?
What is the use of getcommandlineargs() method in c#.net?
How do we get the xmlhttprequest object in ajax?