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
- 10303 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
How to generate sequence numbers using expression transformation?
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
What is sequence generator transformation in informatica?
Which version configuration tool used in ur project?
Name the different lookup cache(s)?
How many numbers of sessions can one group in batches?
Define mapplet?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What is event and what are the tasks related to it?
How many transformations can be used in mapplets.
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What you know about transaction control transformation?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What are the prerequisite tasks to achieve the session partition?
Define enterprise data warehousing?
