split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar
1 14724Source 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 5764There 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 7689can we have to do changes in session property when we are dynamically generating target files?
3 7782If 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 9891Scenario 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 6153Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
1594Post New Wipro Informatica Interview Questions
Explain Continuous and Discrete signals?
what is predefined function in java?
What does SD RAM refers to
What is workspace in excel?
What is alt tag?
What are the access modifiers available in java?
While entering a series of numbers I was manually entering a comma. Excel auto-formatted the field to accommodate the comma like 1,200. I erroneously entered12,00. Obviously the comma was placed in the incorrect position, but excel interpreted this as text. When I wrote my sum formula, the results were not as expected.how can this be avoided in the future?
Does java support multiple inheritance or not?
What is the qtp testing process?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
what is the reqirred voltage in HT motor to get full RPM on no load test?
How can we retrieve the Bug Ids which are open&Reopen in status through QTP scrit?Please find the script which i tried... Dim objBugFactory, objBug Dim BugId Set TDConnection = QCUtil.TDConnection Set objBug = TDConnection.BugFactory If QCUtil.IsConnected then Reporter.ReportEvent 0, "Connected", "Connected to server: " + QCUtil.TDConnection.ServerName + chr (13) +"Project: " + QCUtil.TDConnection.ProjectName + chr (13) + "Domain: " + QCUtil.TDConnection.DomainName Reporter.ReportEvent 0, "Current time on server is","==>" & TDConnection.ServerTime Else Reporter.ReportEvent 1, "Not connected", "Not connected to Quality Center" End If If mybug.Status="Open" Then BugId=mybug.DefectId MsgBox BugId End If 'OR**********************************--------------------- -----********************************** If Bug_Fields("BG_STATUS").Value ="Open" Or "Re Open"Then BugId=Bug_Fields("BG_BUG_ID").Value MsgBox BugId End If
What is the significance of ifsc code?
How do we create a Work Object from Activity?
Is the declaration of a class its interface or its implementation?