whether sorting strings as numbers affects aggregator result

Maximus_Jack · Post by **Maximus_Jack** » Sat Aug 04, 2012 11:23 am

Hi
I don't have access to Datastage now, can anyone please help in giving some
clarity on this, i have a job as

input_seq_file --> aggregator --> output_seq_file

some string columns in the input file are sorted as numeric using the unix command before it gets processed in the aggregator, my question is whether
sorting strings as numbers in anyway affect the result of the aggregator,
the operation performed in aggregator are sum and first.

(my guess is, it should not affect

)

thanks
MJ

chulett · Post by **chulett** » Sat Aug 04, 2012 4:29 pm

"Affect" as in change the result? No. It would mostly just be a waste of time as the Aggregator would need to undo all that work and "sort" the data itself back as a string.

Maximus_Jack · Post by **Maximus_Jack** » Sat Aug 04, 2012 4:40 pm

craig, thanks for responding, I dont have much exposure in server stages,
its seems like the server aggregator needs the data to be sorted, i have now tried simulating the same scenario, i'm getting "row out of sequence" error, is it because the aggregator is getting non sorted data?? correct me if i'm wrong

and also did a bit of reading on this
http://www-01.ibm.com/support/docview.w ... wg21425707

chulett · Post by **chulett** » Sat Aug 04, 2012 10:07 pm

It doesn't need it to be sorted but it will appreciate it.

However, if you tell it that it is sorted you best not be wrong which is what your "out of sequence" error is saying.

Maximus_Jack · Post by **Maximus_Jack** » Sat Aug 04, 2012 10:32 pm

thanks craig