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 14490Source 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 10577Post New Cap Gemini Informatica Interview Questions
What is the need for dmac in es?
How to define values for a testplan attribute?
is indian bank or canara bank CBS brach?
What is the material of E185
Can you slice a tuple?
What is data control language?
Are duplicates allowed in hashmap?
What are the advantages of polymorphism?
How will you differentiate between organized and unorganized sector?
Can we do reporting on non reporting models and assign work status?
What is the purpose of tdevc ?
Can I check the communication of the service channel?
What is recursion in r?
How many end points should a page contains?
What is retail banking?