Interested to Buy Any Domain ? << Click Here >> for more details...
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department.
Write a query
- 7 Answers
- 12418 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / manoj
SELECT *FROM EMP WHERE SAL>(SELECT AVG(SAL) FROM EMP WHERE
DEPTNO=10);
this is correct answer. all the above answer are wrong except last one. Because in single row sub query we can't use group by clause. In all above queries they were used '>' simbol. So this is single row sub query matching operator.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Differentiate between Load Manager and DTM?
What are the different options available for update strategy?
Is there any target staging area in informatica not staging area
In warehouses how many schemas are there?
What is the difference between informatics 7x and 8x and what is latest version?
What is the function of union transformation?
What is a repository manager?
What are the types of caches in lookup?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Explain the code page compatibility?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Explain the different dimensions.
What are the tuning techniques you applied during your last project
can we override a native sql query within informatica? How do we do it?
Have you worked with/created Parameter file
