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

Differentiate between source qualifier and filter transformation?

1579

---

How to differentiate between the active and passive transformations?

1167

---

What is rank transformation in informatica

1179

---

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1294

---

Different circumstance which drives informatica server to expel records?

984

---

What is the meaning of decode in informatica?

1122

---

What is the difference between source qualifier transformations source filter to filter transformation?

1056

---

differences between service based and product based?

2016

---

What is aggregator transformation in informatica?

952

---

How can you increase the performance in joiner transformation?

1191

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

2271

---

During the running session, output files are created by informatica server. Enlist few of them.

982

---

What are batches?

1101

---

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

1041

---

What are the limitations of joiner transformation?

1114

---