Aggregation Bug...

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
rasi
Participant
Posts: 464
Joined: Fri Oct 25, 2002 1:33 am
Location: Australia, Sydney

Aggregation Bug...

Post by rasi »

Hi Users,

It seems that there is a bug in Datastage Aggregation Plug In in Version 6. In the debug I am getting the right answer and when I run this in the director the result are different.

If this is a bug is there any patch

Cheers
Rasi
WoMaWil
Participant
Posts: 482
Joined: Thu Mar 13, 2003 7:17 am
Location: Amsterdam

Re: Aggregation Bug...

Post by WoMaWil »

Before saying it is a buck you should check if the situation is the same. To be able to duplicate you should set a passive stage (Sequential, Hash, Ora ...) directly before and directly after the Agg-Stage.

If it still does work differently you should contact Ascential support.

Wolfgang
rasi
Participant
Posts: 464
Joined: Fri Oct 25, 2002 1:33 am
Location: Australia, Sydney

Post by rasi »

Hi Wolfgang,

I had used the Oracle plug in stage to put the data in staging table and did the aggregation. It works with the database. I will follow up with the Ascential support.

Cheers
Rasi
datastagedummy
Participant
Posts: 56
Joined: Thu Feb 13, 2003 6:08 pm
Location: USA

Re: Aggregation Bug...

Post by datastagedummy »

Check the decimal precision of the numeric value too
Post Reply