Job aborts after 754K recs with Aggregator: %s

vinaymanchinila · Post by **vinaymanchinila** » Thu Jun 30, 2005 7:17 am

Hi Ray,
Should I mention ASC or DSC in the "SORT" column or "SORT ORDER" column of the aggregator?
Thanks,

vinaymanchinila · Post by **vinaymanchinila** » Thu Jun 30, 2005 7:29 am

Hey Guys,
I go to the Input page in the Aggregator and select "Ascending" in the sort order column and when I go to next column the first selection disappears!!!
Is it how it works ?
Thanks

ray.wurlod · Post by **ray.wurlod** » Thu Jun 30, 2005 6:48 pm

The Sort column contains 1, 2, 3 and so on to indicate the order in which the columns are known to be sorted; this would correspond to the order of column references in an ORDER BY clause.

The Sort Order column has a drop down list from which you can choose Ascending or Descending as the order of sort.

As for disappearing specifications, you appear to have a bug in the client. Or perhaps you're not entering 1, 2, 3 in order. Having clicked OK (to save changes) and re-opening the Aggregator stage, do your specifications reappear? If not, notify the problem to your support provider.

Tip: To remove a "column is sorted" specification, put 0 in the Sort cell. An attempt to clear the cell will not work; you have to put 0 in there.

chulett · Post by **chulett** » Thu Jun 30, 2005 8:12 pm

ray.wurlod wrote:As for disappearing specifications, you appear to have a bug in the client. Or perhaps you're not entering 1, 2, 3 in order.

The latter, sorta. It happens when you put in a Sort Order and don't put in a Sort sequence number. Once you move off the row the gui removes the sort order since that field wasn't marked as 'sorted'.

ray.wurlod · Post by **ray.wurlod** » Fri Jul 01, 2005 6:50 pm

If I were the author of the stage, I would see that behaviour as an entirely reasonable approach.

chulett · Post by **chulett** » Fri Jul 01, 2005 9:49 pm

As a user of that stage I see that behaviour as an entirely reasonable approach.