Answer Posted / infa

If Your Source is Flat file then

1. Sort the sal column in Desc order

2. generate the sequence rownumber either by using a sq
genrator or Exp Transformation say v_count+1

3. use a filter condition and give the filter value as
v_count <= 10

4.Load into the target.

If your source is DB
then use below query

SELECT *FROM
(
SELECT *FROM emp
ORDER BY Sal desc
)
WHERE rownum <= 10
ORDER BY Sal;

Thanks

cheers

What is standalone command task?

818

---

Tell me about Propagate functions in informatica

620

---

What is enterprise data warehousing?

695

---

Differentiate between a repository server and a powerhouse?

670

---

What is native users?

801

---

---

What are the main issues while working with flat files as source and as targets ?

748

---

what is size of u r database?

1942

---

Explain lookup transformation in informatica

736

---

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

789

---

What are the performance considerations when working with aggregator transformation?

780

---

can we override a native sql query within informatica? Where do we do it?

736

---

Whats there in global repository

1347

---

What is workflow monitor?

695

---

What are the new features of informatica 9.x in developer level?

645

---

How might you approve all mappings in the archive all the while?

707

---