✍ Kashif M
Trends

Sunday, 26 January 2014


cumulative Sum or moving sum in Informatica


By on January 26, 2014




CUME (PERSONAL_SALES)

 PERSONAL_SALES      RETURN VALUE
40000                40000
80000                120000
40000                160000
60000                220000

MOVINGSUM (SALES,2)

ROW_NO              SALES      RETURN VALUE
1                600               NULL
2                504               1104 (600+504)
3                36                 540 (504+36)
4                100               136 (36+100)
5                550               650 (100+550)
6                39                 589 (550+39)
7                490               529 (39+490)

Kashif
mkashu: cumulative Sum or moving sum in Informatica
Review : Kashif | Kashif
Update: January 26, 2014 | Rating: 4.5

Comment for "cumulative Sum or moving sum in Informatica"

0 comments

Post a Comment

Blog Archive