Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 14601 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / sbvp
update emp set sal=sal+500
or
alter table emp modify sal=sal+500
| Is This Answer Correct ? | 1 Yes | 28 No |
Post New Answer View All Answers
How does a sorter cache works?
How to load the data from a flat file into the target where the source flat file name changes daily?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is rank transform?
Explain constraint based loading in informatica
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Explain why we use partitioning the session in informatica?
As union transformation gives UNION ALL output, how you will get the UNION output?
can anyone explain me about retail domain project in informatica?
write a query to retrieve the latest records from the table sorted by version(scd)
where to store informatica rejected data? How to extract the informatica rejected data?
what is the -ve test case in your project.
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Which is the t/r that builts only single cache memory?
What is workflow? What are the components of workflow manager?
