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

can anyone explain me about retail domain project in informatica?

7998

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2443

---

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1306

---

Which version configuration tool used in ur project?

3321

---

can you please explain me pre session and post session options?

7672

---

Different qualification between a related rotate toward the sky and isolates look upward?

1037

---

What is complex mapping?

1171

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1166

---

What will be the approach?

1037

---

generate date / time dimension in informatica

1160

---

What is native users?

1222

---

Explain dynamic target flat file name generation in informatica

1109

---

Define update strategy?

1315

---

State the limitations where we cannot use joiner in the mapping pipeline?

1106

---

What is the way to execute pl/sql script using informatica mapping?

1681

---