DSXchange

hi

i am reading data from oracle table emp: the data look like this...

empno deptno sal
1 10 1000
1 20 2500
1 10 3000
2 10 2500
2 30 500
2 20 2100

i want report like this
maxsal empno deptno no.of emp in dept

pls tell me it can be write in sql query or using any stage in datastage.



thnks
venkat

This looks like an ideal task for an Aggregator stage. You could also do it in SQL using MAX and COUNT set functions.