Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the 5th highest salary form each department
using 1.SQL Query
2. Informatica power center designer?
- 4 Answers
- 26230 Views
- CTC, I also Faced
- E-Mail Answers
Answer Posted / saleem
SQL query:
select rownum,empno,ename,job,sal from (select
rownum,empno,ename,job,sal from emp rder by sal desc)
group by rownum,empno,ename,job,sal having rownum =&n;
(with this query we will get which highest salary u want)
| Is This Answer Correct ? | 3 Yes | 9 No |
Post New Answer View All Answers
whats the logic to load the lower level of granularity of data to fact table.
What are mapplets?
Name the different lookup cache(s)?
how to load dimension table and fact table. plz tell me the steps.
What is substr in informatica?
Explain pushdown optimization and types in informatica
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
How can you generate reports in informatica?
What is the use of source qualifier?
What is target designer and target load order?
What is joiner transformation in informatica?
Explain the types of lookup transformation?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
