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 11876Source 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 9094Post New Cap Gemini Informatica Interview Questions
How do I delete specific words in excel?
How can I do serial ("comm") port I/O?
How to display seconds, minutes, tracks of an AVI ?
when sitelinks are set at both the campaign and ad group level, which will be displayed?
Explain OLE Drag and Drop.
What are the system fields?
Which variables are stored in heap?
Can we save file in database?
How do I run flex as a service?
Explain what is the main difference between inmon and kimball philosophies of data warehousing?
Tell me how can we change the maximum size of the files to be uploaded?
Explain how you can generate schedule VI profit & loss account using auditors edition of Tally ERP 9?
What exactly do you know about catching in teradata?
What is the difference between float and double?
Explain the difference between a canyon, gorge, and valley?