Interested to Buy Any Domain ? << Click Here >> for more details...
If sal is null then replace it with min(sal). Can any one
write a query for this in oracle ?
Advance Thanks
- 7 Answers
- 10602 Views
- Puma, I also Faced
- E-Mail Answers
Answer Posted / basavan
select nvl(sal,min(sal) from <table name>
| Is This Answer Correct ? | 1 Yes | 8 No |
Post New Answer View All Answers
What is standalone command task?
Performance tuning( what you did in performance tuning)
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Write the program through which the records can be updated?
can you please explain me pre session and post session options?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is a rank transform?
How to update or delete the rows in a target, which do not have key fields?
What are roles and groups and benefits of using them?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Can we create a node as a gateway node and the same node can be assigned to a grid?
can anyone explain me about retail domain project in informatica?
What is sequence generator transformation in informatica?
Explain incremental aggregation in informatica
