Answer Posted / amjad

Hi Naga,
If we use Aggregator stage, it will give the max value from
different groups, as per your example, it will group by
company, then it will give the max sal from each group. but
how to max sal from all the groups, i mean the out put
should be only one value.

Ex:

COMPANY,SAL
A, 2000
B, 3000
C, 4000
A,5000
B,6000
C,7000
A,8000
B,9000
C,9999

if we do like you mention output will be like :
comp,maxsal
A,8000
B,9000
C,9999

But, the output should be only
C,9999

Plese let me if iam wrong.

How the ipc stage work?

1170

---

How many areas for files does datastage have?

1218

---

Lookup constraints

1307

---

What is the difference between passive stage and active stage?

1644

---

How many types of sorting methods are available in datastage?

1115

---

What are the differences between datastage and informatica?

1229

---

What are the features of datastage flow designer?

1099

---

What is use Array size in datastage

1826

---

What is the different type of jobs in datastage?

1030

---

What are the functionalities of link partitioner?

1067

---

What is the difference between validated and compiled in the datastage?

1372

---

What is the difference between odbc and drs stage?

1135

---

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3292

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

969

---

What are the processing stages?

1151

---