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
- 14391 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
What is pmcmd command?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
How to generate sequence numbers without using the sequence generator transformation?
Parameter and variable differences
Did u used latest transformations of 8.6.0? for what?
What is dynamic cache?
Why do we need informatica?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is domain in terms of informatica?
Differentiate between source qualifier and filter transformation?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Global and Local shortcuts. Advantages.
What are the components of workflow manager?
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
What is source qualifier transformation in informatica?
