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
whether sorting strings as numbers affects aggregator result
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 139
- Joined: Fri Apr 11, 2008 1:02 pm
-
- Premium Member
- Posts: 139
- Joined: Fri Apr 11, 2008 1:02 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
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