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 14398Source 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 10514Post New Cap Gemini Informatica Interview Questions
What is the importance of Site map in CRM?
Explain about the $_GET variable of PHP?
How do I delete emails in bulk?
How can i execute PHP File using Command Line?
What happen when too much cylinder oil is injected in the working cylinder?
How do you calculate load bearing capacity of a waffle slab?
What is content query web part?
What are local static variables?
What do you understand by R cluster analysis?
What is dhcp pool?
Why update strategy and union transformations are active? Explain with examples.
List 5 words that best Describe your strengths? List 5 words that best Describe your weakness?
How many ways to create workflows? Which is the best?
Explain the reproductive strategies and processes observed in Acoelomates.
What is out parameter used for eventhough return statement can also be used in pl/sql?