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.

Explain the datastage parallel extender (px) or enterprise edition (ee)?

1171

---

Explain how a source file is populated?

1311

---

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

1683

---

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

3129

---

What are the different kinds of views available in a datastage director?

971

---

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

2756

---

Difference between server jobs & parallel jobs?

1015

---

How do u convert the columns to rows in datastage?

1139

---

What is oci?

1259

---

How complex jobs are implemented in datstage to improve performance?

962

---

What is the process of killing a job in datastage?

961

---

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1295

---

What is the difference between orabulk and bcp stages?

966

---

How to clean the datastage repository?

1068

---

What are the components of ascential data stage?

1110

---