Answer Posted / abhilash

do following steps

1.in source qualifier override the query with
"order by salary desc"

2. use seq gen tr on it and give column name as "sid"

3. next use filter tr. in that write condition like "sid<=10"

What are the performance considerations when working with aggregator transformation?

1119

---

What is a dimensional model?

949

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1466

---

What happens when a session fails and you click on recover?

1093

---

tell me the rules and responsblites in our project(my project is development)

1896

---

What is the advantage of informatica?

1027

---

can u give example for factless fact table

6498

---

Separate from a database, an information bazaar, and an information stockroom?

1043

---

How can we delete duplicate rows from flat files?

1181

---

What is the surrogate key?

1182

---

Explain lookup transformation source types in informatica

1060

---

How to call shell scripts from informatica?

952

---

Design a mapping to load a target table with the following values from the above source?

1309

---

What is transformation?

1069

---

Explain informatica architecture - version 8 / 9

1047

---