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
- 14405 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 mapplets? How is it different from a Reusable Transformation?
What are the advantages of using informatica as an etl tool over teradata?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
r u done any partitions in ur project?
How to update a particular record in target with out running whole workflow?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How do we call shell scripts from informatica?
What are the performance considerations when working with aggregator transformation?
How do you load first and last records into target table?
What is an Integration service in Informatica?
Explain what are the different types of transformation available in informatica.
What do you mean by channel change?
can you please explain me pre session and post session options?
Enlist the advantages of informatica.
Explain where to store informatica rejected data? How to extract the informatica rejected data?
