Aggregation in Transformation Stage

ravi7487 · Post by **ravi7487** » Tue Feb 08, 2011 12:19 am

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?

ray.wurlod · Post by **ray.wurlod** » Tue Feb 08, 2011 12:20 am

No.

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

If you want to aggregate, use an Aggregator stage.

ravi7487 · Post by **ravi7487** » Tue Feb 08, 2011 12:22 am

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

ray.wurlod · Post by **ray.wurlod** » Tue Feb 08, 2011 12:49 am

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.

ravi7487 · Post by **ravi7487** » Tue Feb 08, 2011 12:51 am

Thanks Ray.