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?
Aggregation in Transformation Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
Last edited by ray.wurlod on Tue Feb 08, 2011 12:53 am, edited 1 time in total.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.