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
- 14097 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / sbvp
update emp set sal=sal+500
or
alter table emp modify sal=sal+500
| Is This Answer Correct ? | 1 Yes | 28 No |
Post New Answer View All Answers
How do you set a varible in incremental aggregation
Explain the scenario which compels informatica server to reject files?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
how to load dimension table and fact table. plz tell me the steps.
Is there any target staging area in informatica not staging area
pmscmd startworkflow -sv
can anyone suggest best free Talend data integration training online
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Mention few advantages of router transformation over filter transformation.
my source is junk data how will u remove that junk data by using unix please any one replay me
What is mapplet in informatica?
What are pre and post-session shell commands?
What is the function of look up transformation?
What is the Process to creating lookup transformation in informatica
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
