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
- 14608 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
Reusable transformation and shortcut differences
r u done any partitions in ur project?
What are the components of workflow manager?
What are the new features of informatica 9.x at the developer level?
Enlist few areas or real-time situations where informatica is required.
list out all the transformations which use cache?
Explain incremental aggregation in informatica
explain abt ur project architecture?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Why union transformation is an active transformation?
how tokens will generate?
How do you manage the Parameter files while migrating your data from one environment to another environment?
On which transformations you created partitions in your project?
What is joiner transformation?
What do you mean by enterprise data warehousing?
