Aggregator warning as viewed in director log

samplify · Post by **samplify** » Wed Sep 07, 2005 9:25 am

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

roy · Post by **roy** » Wed Sep 07, 2005 2:34 pm

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,

kumar_s · Post by **kumar_s** » Wed Sep 07, 2005 10:55 pm

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

roy · Post by **roy** » Wed Sep 07, 2005 11:07 pm

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

kumar_s · Post by **kumar_s** » Thu Sep 08, 2005 2:58 am

Oppsss!!!!
I often get mislead with roy with ray and ray with roy....
i know genious think alike, but i wonder how even name sound alike...

regards
kumar

ray.wurlod · Post by **ray.wurlod** » Thu Sep 08, 2005 4:07 pm

My nick was never ray - on any site. :D