Answer Posted / subhash

Src ---> Tfm ---> Tgt
in the TRANSFORMER Stage.

Do the HASH partitioning the incoming data and 'Perform
Sort' on DEPTNO ASC order and SAL DESC order.

and use 2 STAGE VARIABLES sv1=0 & sv2=0.

sv2 ===> If sv1=DEPTNO Then sv2+1 Else 1
sv1 = DEPTNO

And Put the below Link contraint:
sv2=3


Then u will get 3rd highest SAL from each DEPT.

Have you have ever worked in unix environment and why it is useful in datastage?

1134

---

Differentiate between hash file and sequential file?

1077

---

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2277

---

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

3126

---

What is the project in datastage?

1116

---

how to implement scd2 in datastage 7.5 with lookup stage

5610

---

How do you register plug-ins?

968

---

Notification Activity

1415

---

Define project in datastage?

1103

---

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1418

---

Is the value of staging variable stored temporarily or permanently?

1004

---

If you want to use the same piece of code in different jobs, how will you achieve it?

1161

---

What is a quality stage in datastage tool?

1081

---

Explain entity, attribute and relationship in datastage?

1111

---

what is ds administrator used for?

1175

---