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
- 14303 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
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is incremental aggregation?
Write the unconnected lookup syntax?
What is exclusive and normal mode for repository services?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What do you mean incremental aggregation?
what is $$$$?
What is enterprise data warehousing?
explain about unit testing? in real time?
What is workflow manager?
What is dimensional table? Explain the different dimensions.
What is the difference between STOP and ABORT options in Workflow Monitor?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
how many types of dimensions are available in informatica?
What is informatica metadata and where is it stored?
