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 14109Source 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 10325Post New Cap Gemini Informatica Interview Questions
Can't one material be assigned to more than one operation in a routing, why?
Define a company's payable cycle?
How would you conduct a UX research study to improve UX on Amazon page with books?
Whether should be the oil level in OCTC transfomer? It should be upto winding immersed completely or should be upto tap changer s/w? How it will affect the performance of the transformer. Rating may be 33KVA
How to do logs in automation anywhere?
How do you turn a percentage into a number?
Is there an equivalent of exit() for quitting a c# .net application?
Is xslt a programming language?
Identify the various components of Visual Studio IDE?
Does law school require a political science/international studies major?
How do you convert a string to in python?
why do we put a transformer on soak before loading it
What are the modulation techniques used in bluetooth technology?
what is the difference between Xcode, Cocoa and Objective C?
When multiple after triggers are attached to sql table, how to control the order of execution?