DSXchange

Hi All

I am making simple job like this:-

Ddataset--->aggrigator stage ------>Dataset

Input columns are :-
Columns Data types
HUB Varchar
CIRCLE Varchar
DATE Date
AMOUNT Decimal (10,4)

I want sum of amount column basced on
HUB,CIRCLE and DATE

I have selected these in aggrgator stage:-
Grouping keys:-
HUB, CIRCLE and Date
Aggrigation
aggrigation Type =Calculation
Col. For cal=AMOUNT
Sum o/p col=SUM_AMOUNT
Default to decimal o/p=8,2
and partitioning is hash on key columns
But in o/p i m getting null record in SUM_AMOUNT column

Please help me to resolve this problem
Thanks in advance

Firstly why? Here you are trying to squeeze your input (10,4) to (8,2) which needs to be looked into. Also how does your input data looks, does it have any Null values?

us1aslam1us wrote:Firstly why?

Code: Select all

Default to decimal o/p=8,2

Here you are trying to squeeze your input (10,4) to (8,2) which needs to be looked into. Also how does your input data looks, does it have any Null values?

I have chaged the input to (8,2) but still the same problem,and yes input data have the NULL values......