split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar
1 15719Source 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 6677There 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 9022can we have to do changes in session property when we are dynamically generating target files?
3 9024If 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 11631Scenario 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 7699Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
2012Post New Wipro Informatica Interview Questions
What type of workflow alerts are there?
What is an AMI? How do we implement it?
What is a dictionary in python?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
Explain me what is a built-in function that python uses to iterate over a number sequence?
How do you format a table of contents?
What is a production ruleset ? How will it be helpful ?
What is web jobs in Azure?
When is a binary search best applied?
What are types of dependency injection?
Is windows operating system free?
Tell me which tool installs dll on local computer and installs the windows service in transactional manner?
what is msl?
Tell me what is meant by “business content” in sap?
Explain the characteristics of rpa?