Hi Jagan,
My idea is to assign a 0 when there is a null, when we group it,
so this can be achieved just simply using Sum(Sales) as Sales
When we use Sum(Sales) the null values are treated as 0 right. then why are we using alt(sum(sales),0)
Does this alt function affects performance of the load when dealing with 25 millions of records
Test:
Load,
ID,
Alt(sum(sales), 0) as Sales
resident abc group by ID;
Regards
Renjith
