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.

What is informatica powercenter repository?

1140

---

Clarify the aggregator change?

970

---

How can we remove the duplicates from flat file source?

947

---

Have you worked with/created Parameter file

1610

---

Sequence generator, when you move from develoment to production how will you reset

1939

---

r u done any partitions in ur project?

1750

---

What does refresh system mean, and what are its distinctive choice?

1071

---

What are the tasks that source qualifier perform?

1029

---

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3811

---

Do you find any difficulty while working with flat files as source and target?

1050

---

Partition, what happens if the specified key range is shorter and longer

2432

---

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

990

---

How to create or import flat file definition in to the warehouse designer?

1020

---

COM components can be used in Informatica

2312

---

how many types of dimensions are available in informatica?

996

---