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
- 26097 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
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
How to go to the older version for a mapping?
Differentiate between Load Manager and DTM?
lookup transformation with screenshots
how many types of dimensions are available in informatica?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
How to use procedural logic inside infromatica?
What is rank index in rank transformation?
What is substr in informatica?
What is decode in informatica?
Differences between version 7.x and 8.x.
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
How do you handle two sessions in Informatica
What are the designer tools for creating transformations?
Explain sessions and how many types of sessions are there?
