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
- 14596 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
How to do unit testing in informatica? How to load data in informatica ?
Explain about cumulative Sum or moving sum?
What is the difference between stop and abort in informatica
Name the different lookup cache(s)?
What are the new features of informatica 9.x at the developer level?
What are the uses of etl tools?
What are the designer tools for creating transformations?
When do you use sql override in a lookup transformation?
What is meant by incremental aggregation?
Where can we find the throughput option in informatica?
What is a code page?
What is fact table? Explain the different kinds of facts.
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What do you mean incremental aggregation?
Define sessions in informatica etl?
