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 14431Source 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 10532Post New Cap Gemini Informatica Interview Questions
How would you evaluate the inventory performance ? What is Inventory Turn Over ratio and what would you recommend to increase it under a set of assumptions.
what is a constraint? Tell me about its various levels. : Sql dba
Explain the difference between sap r/2 and r/3?
What is ORM?
What principles guide ethical AI development?
During which test activity could fault be found most cost-effectively?
How do you secure repository?
In Perl, there are some arguments that are used frequently. What are that arguments and what do they mean?
What are the steps to create a progress bar using bootstrap?
What is meta tag in html?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
Is encoding necessary for rpa?
How many employees do you have? - Venture Capitalists
What are assemblies?
What do the keywords volatile and mean mutable?