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.

Whats difference betweeen operational data stage (ods) and data warehouse?

1116

---

What is the purpose of pivot stage?

1169

---

What is the difference between in process and inter process?

1149

---

Describe the main features of datastage?

1076

---

Explain the importance of surrogate key in data warehousing?

1191

---

Differentiate between datastage and informatica?

1183

---

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2375

---

How do you reject records in a transformer?

1125

---

To see hidden files in LINIX?

1530

---

how to add a new records into source?

2000

---

What is a merge?

1170

---

Define oconv () and iconv () functions in datastage?

1416

---

What all are the different way to run a job?

1095

---

Define project in datastage?

1095

---

I have a few records just I want to store data in to targets cycling way how?

2366

---