Hi:
I am using group property in aggregator to group columns according to the requirement...however i get the following warning when i try to view log in datastage director...
AGG040: When checking operator: User inserted sort "SRT030" does not fulfill the sort requirements of the downstream operator "APT_SortedGroup2Operator in AGG040"
Any idea what its all about?
Efforts for replying appreciated..
Sam
Aggregator warning as viewed in director log
Moderators: chulett, rschirm, roy
Hi and Welcome Aboard
,
In aggregator stage you can specify that you have presorted the data on certain column/s.
This is done to improove performance, basicly you say that once you encounter a new entry in the columns you specified the sort was on the aggregator stage can assume it won't get any more results with the previous combinations of those column/s, so the aggreagtor stage can down-stream the computed results of those grouped columns.
Your error simply says: Hey you said the data was sorted but it's not
So you simply need to make sure the data is sorted the way you said it is.
Since it's your first post please make sure you go thru the docs on how to use that stage.
IHTH,
![Smile :)](./images/smilies/icon_smile.gif)
In aggregator stage you can specify that you have presorted the data on certain column/s.
This is done to improove performance, basicly you say that once you encounter a new entry in the columns you specified the sort was on the aggregator stage can assume it won't get any more results with the previous combinations of those column/s, so the aggreagtor stage can down-stream the computed results of those grouped columns.
Your error simply says: Hey you said the data was sorted but it's not
![Exclamation :!:](./images/smilies/icon_exclaim.gif)
So you simply need to make sure the data is sorted the way you said it is.
Since it's your first post please make sure you go thru the docs on how to use that stage.
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Hi sam,
Ray has already answered for the same question. Still he is cool to repeat the answer to you in the different form
.
click the link to have a look....
viewtopic.php?t=95001
regards
kumar
Ray has already answered for the same question. Still he is cool to repeat the answer to you in the different form
![Wink :wink:](./images/smilies/icon_wink.gif)
click the link to have a look....
viewtopic.php?t=95001
regards
kumar
That's why Ray changed he's nick from just ray to he's full name (saving me the bother of doing it
)
I'm Roy He's Ray![Wink :wink:](./images/smilies/icon_wink.gif)
![Wink ;)](./images/smilies/icon_wink.gif)
I'm Roy He's Ray
![Wink :wink:](./images/smilies/icon_wink.gif)
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: