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.

Differentiate between sessions and batches?

1027

---

How we can create indexes after completing the loan process?

1220

---

Please let me know how to make Data masking in informatica..

1739

---

How do you change a non-reusable transformation to reusable transformation?

1006

---

How to load the data from a flat file into the target where the source flat file name changes daily?

1074

---

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

1216

---

What is Cognos script editor?

4240

---

How can we use mapping variables in informatica? Where do we use them?

1213

---

How can you validate all mappings in the repository simultaneously?

1381

---

Explain the different lookup methods used in informatica?

1053

---

wf dont have integration severances how you can run?

1947

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5805

---

is it possible to index the data in cache of lkp transformation ?

2035

---

what is the difference between informatica6.1 and infomatica7.1

2287

---

can anyone explain me about retail domain project in informatica?

7956

---