DSXchange

Hi,

Could you please let me know how to perform aggregation in transformation stage.

Source data

Deptno,sal
10,200
20,300
30,400
20,300
10,300
30,400

I want to aggregate data by deptno wise in tranformation stage? How can i acheive this?

No.

The philosophy of DataStage is one stage type, one task.

If you want to aggregate, use an Aggregator stage.

Thanks for replying Ray.

But is it atleast possible to get the sum of salary by deptno using tranformation stage. Please let me know if its possible. Interviwer asked me this question

Thanks

Of course it's possible.

But it's wrong.

Would you (or your interviewer) use a hammer to tighten a screw? It's possible, but it's the wrong tool for the job.

Thanks Ray.