Answer Posted / rakhee

No need to use any transformation.
Double click on SQ emp
go to property
click on SQL query
browse it

write query
SELECT EMP.EMPNO, EMP.ENAME, EMP.JOB, EMP.MGR, EMP.HIREDATE, EMP.SAL, EMP.COMM, EMP.DEPTNO
FROM
EMP
WHERE
ROWNUM<=10
ORDER BY SAL DESC

validate it
OK

How to differentiate between the active and passive transformations?

1169

---

How many types of sessions are there in informatica.please explain them?

1170

---

Make a note of the quantity vaults made in informatica?

988

---

What is the advantage of informatica?

1069

---

Why do we need informatica?

998

---

Explain Dataware house architecture .how data flow from intial to end?

2587

---

can u give example for factless fact table

6655

---

How might one distinguish in the case of mapping is right or not without associating session?

1129

---

Can anyone tell me the new features in Informatica 9 Version?

2132

---

Performance tuning in UNIX for informatica mappings?

2570

---

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2080

---

What is the use of transformation?

1000

---

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1133

---

How can we improve session performance in aggregator transformation?

1117

---

wf dont have integration severances how you can run?

1941

---