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
- 11854 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / srinu
Hi Sanjaygupta1981,
Can you please check the query once :
count(*) or count(hiredate).
Except Count(*) Your query looks good.
If any correctons in my advise please let me
know "srinu.srinuvas@gmail.com"
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
Separate from an archive server and a powerhouse?
To import the flat file definition into the designer where should the flat file be placed?
What is exclusive and normal mode for repository services?
What is a mapplet/worklet in informatica?
what is mean by complex business rule ?
Suppose we do not group by on any ports of the aggregator what will be the output?
How do you use reject loader.
Where is metadata stored?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Quickly characterize reusable change?
How to generate sequence numbers without using the sequence generator transformation?
What are the components of the workflow manager?
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
How to use pmcmd utility command?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
