Aggregation on a single field
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
Aggregation on a single field
Hi I have few columns comming from source, and I need to aggregate only one column and pass the rest of them as it is without applying any logic or aggregation on the rest of the columns.
The isue is when I use the aggregator stage, I HAVE TO select some kind of aggregation on every column , is there a way we can skip it!
Thanks,
The isue is when I use the aggregator stage, I HAVE TO select some kind of aggregation on every column , is there a way we can skip it!
Thanks,
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
So, you'd want all of these 'non-grouped' fields to have the one grouped field repeated on each record? I'm a little lost here.
If this is really what you meant, I'd think you'd need to make two passes through the data - once to get the sum per 'key group' and then another pass to associate that sum with every detail record.
If this is really what you meant, I'd think you'd need to make two passes through the data - once to get the sum per 'key group' and then another pass to associate that sum with every detail record.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Think about how you would do it in a query. You'd almost certainly need a temporary table (virtual or physical) in which to store the keys and associated sums, so that you could join this with the original result set.
Well, no surprise, the processing isn't really any different in DataStage; you just get to draw the pictures rather than creating the SQL.
Well, no surprise, the processing isn't really any different in DataStage; you just get to draw the pictures rather than creating the SQL.
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.