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.

Can you explain how could anyone drop the index before loading the data in target in datastage?

1510

---

What are routines in datastage?

1338

---

Differentiate between datastage and informatica?

1194

---

What is the difference between orabulk and bcp stages?

1033

---

What is orabulk stage?

1058

---

What are the primary usages of datastage tool?

1078

---

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2819

---

What is the roundrobin collector?

1103

---

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2274

---

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1561

---

Can you explain engine tier in information server?

1142

---

What is a folder? Difference types of stages?

1184

---

How to clean the datastage repository?

1133

---

How can we improve the performance in datastage?

1108

---

What is merge stage?

1323

---