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 Answers
- 11847 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / srinivas
Hi suraj no need to put first group by and then having
clause
we can give any order it will work
please check and let me know
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
How many input parameters can exist in an unconnected lookup?
what is INFORMATICA TESTING process
COM components can be used in Informatica
What is persistent lookup cache?
What is event and what are the tasks related to it?
What is a surrogate key?
What is the command used to run a batch?
Explain why we use partitioning the session in informatica?
4 yrs etl devloper roles and responsibilities?any body give solutions
What are the types of caches in lookup?
Where do we use mapping variables in informatica?
What is an unconnected transformation?
What are Dimensional table?
design of staging area?
