Answer Posted / suraj kedia

There are 3 ways to find out the nth highest salary in a
given table (e.g. emp) as below;

1) select distinct sal from emp e1 where &n=(select count
distinct sal from emp e2 where e1.sal <=e2.sal);


2) select empno,enaame,sal,deptno,rank () over (order by sal
desc) as ra from emp where ra=&n;

3) select empno,enaame,sal,deptno,dense_rank () over (order
by sal desc) as ra from emp where ra=&n;


All the above methods are tried n tested....it works
successfully.




What is a Cursor.

When a query is executed in oracle, a result set is produced
and stored in the memory. Oracle allows the programmer to
access this result set in the memory through cursors.

Why use a cursor?

Many times, when a query returns more than one row as a
result, we might want to go through each row and process the
data in different way for them. Cursor is handy here.

Types of cursors:

Oracle PL/SQL declares a cursor implicitly for all queries
and DML statements (including queries that return only one
row). But in most of the cases we don’t use these cursors
for queries that return one row. Based on this, there are 2
types of cursors

1. Explicit cursor
2. Implicit cursor

How do you migrate data from one environment to another?

1041

---

What are the types of presistent cache in look up tr.

2004

---

Suppose we do not group by on any ports of the aggregator what will be the output?

981

---

What are the uses of etl tools?

1064

---

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1264

---

Under which circumstances, informatica server creates reject files?

1025

---

Target increases every day even though no new record was inserted

1513

---

How would you copy the content of one repository to another repository?

948

---

explain about unit testing? in real time?

2132

---

In how many ways we can create ports?

1066

---

What are the tasks that source qualifier perform?

1027

---

What is the benefit of session partitioning?

1039

---

What is source qualifier transformation in informatica?

945

---

What are batches?

1009

---

How are the sources and targets definitions imported in informatica designer?

1048

---