Answer Posted / ram

1. nth highest salary

-> select *from emp e where &n =(select count(distinct sal)
from emp m where e.sal <= m.sal);


2. -> 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.

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.

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2359

---

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2325

---

What is a mapplet/worklet in informatica?

1188

---

What is deployment group?

1216

---

What is a joiner transformation and why it is an active one?

1083

---

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

1040

---

How can you define user defied event?

1031

---

What is a joiner transformation?

997

---

what is index?how it can work in informatica

2041

---

What are the components of Informatica? And what is the purpose of each?

1055

---

Enterprise data warehouse your projects phase by phase explain?

1922

---

Explain the tuning lookup transformation - informatica

996

---

How do we call shell scripts from informatica?

1121

---

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

1606

---

How do you load first and last records into target table?

1159

---