If sal is null then replace it with min(sal). Can any one
write a query for this in oracle ?
Advance Thanks
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
How are the sources and targets definitions imported in informatica designer?
What is option by which we can run all the sessions in a batch simultaneously?
What is an aggregator transformation?
How to differentiate between the active and passive transformations?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is the fact table?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
How do you migrate data from one environment to another?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Difference between Target-based loading and constraint-based loading?
What is aggregator transformation in informatica?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How does a rank transform differ from aggregator transform functions max and min?
How do you load first and last records into target table?