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 14394Source 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 10511Post New Cap Gemini Informatica Interview Questions
What is difference between inner join and full join?
Is a subdomain a separate website?
Differentiate between .ear, .jar and .war files.
How long will windows server 2012 be supported?
What is the difference between an implicit intent and explicit intent?
how can we implement locks in plsql?
What is the use of Hyperlink control for DHTML applications?
How many worksheets I can put in a workbook?
What is the distinction between a fast filter and traditional filter in tableau?
What is html head?
Can you define a checkpoint?
Explain how to install installing mariadb on homestead?
Who invented mvc?
Define what do you understand by reverse saturation current of a diode?
What are “lost updates”?