Job design issue

[prasson_ibm]

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

[us1aslam1us]

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?

[prasson_ibm]

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......