In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query
8 10936Source 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 How to do the above scenario in Informatica.
4 8542Post New Cap Gemini Informatica Interview Questions
Which sort is best for the set: 1 2 3 5 4 a) Quick Sort b) Bubble Sort c) Merge Sort
Explain the use of show option in imp command.
a.what products does your firm produce? b.what costs are asssigned to the product produced? c.for particular product,what direct materials are used? d.what percentage of total manufactoring costs is direct labor? direct materials?overhead? e.how is overhead assigned to the products? f.do you now use or plane to use an activity_based management system?why or why not?
What are the template tags in WordPress?
What does xml stands for?
Is mac a linux or darwin?
What is serialization in dot net?
Can you tell me about data import wizard?
Is Blue Prism open source tool?
How many systems are there in a human body?
How to create an array of a group of items inside an html form?
What is the array and initializing arrays in c++?
Why do you want to study business management?
Meaning of portfolio management?
Explain what is infrastructure in wi-fi?