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
- 14094 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
difference between repository database and repository service?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
list out all the transformations which use cache?
How can we use mapping variables in informatica? Where do we use them?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What do you understand by term role-playing dimension?
What is Index Caches size?
What is enterprise data warehousing?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is meant by LDAP users?
What are the databases that informatica can connect to windows?
What is an Integration service in Informatica?
What are the various types of transformation?
How to extract the informatica rejected data?
How can a transformation be made reusable?
