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.

Define Merge?

1314

---

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2101

---

what is the difference between == and eq in UNIX shell scripting?

1498

---

Explain Quality stage?

1145

---

CHANGE CAPTURE

1298

---

What is aggtorec restructure operator?

1435

---

What is merge stage?

1301

---

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3644

---

Can you explain tagbatch restructure operator?

1169

---

Have you used Unstructured data?

1314

---

Enlist various types of routines in datastage.

1249

---

How and where you used hash file?

1168

---

Explain connectivity between datastage with datasources?

971

---

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

1221

---

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

777

---