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.

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

1032

---

Notification Activity

1350

---

Different ways a project can be moved to production ?...example ….export-import and Version control.

2391

---

What is the use of hoursfromtime() function in transformer stage in datastage?

1001

---

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1687

---

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

2171

---

Can you define merge?

1065

---

What are the functionalities of link partitioner and link collector?

952

---

Explain Quality stage?

1089

---

On which Dimension Table you implemented SCD Type in your Project

1971

---

Can we use target hash file as a lookup ?

3264

---

To see hidden files in LINIX?

1454

---

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2407

---

How the ipc stage work?

1080

---

what is ds administrator used for?

1113

---