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
Job design issue
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
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?
Code: Select all
Default to decimal o/p=8,2
I haven't failed, I've found 10,000 ways that don't work.
Thomas Alva Edison(1847-1931)
Thomas Alva Edison(1847-1931)
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
I have chaged the input to (8,2) but still the same problem,and yes input data have the NULL values......us1aslam1us wrote: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?Code: Select all
Default to decimal o/p=8,2