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
- 26029 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
waht type of interface is used for testing the data in informatica
How you can differentiate between connected lookup and unconnected lookup?
What is xml source qualifier transformation in informatica?
How we can create indexes after completing the load process?
What is a node in Informatica?
Reusable transformation and shortcut differences
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Explain the different lookup methods used in informatica?
What is the use of target designer?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Define enterprise data warehousing?
