Search found 3 matches

by nmadhu.etl
Thu Jun 14, 2012 4:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to get cumulative sum
Replies: 14
Views: 7915

Re: how to get cumulative sum

sorry actually i want to said this one

sal -> sv1

sv1+sv3 -> sv2 this one drag to cum_column

sv2 -> sv3

without sv3 also working previous one
by nmadhu.etl
Thu Jun 14, 2012 3:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to get cumulative sum
Replies: 14
Views: 7915

Re: how to get cumulative sum

hi,

this will get by using transformer stage.
here u can take three stage variables like sv1,sv2,and sv3.
Assign default values as 0.

sal -> sv1

sv1+sv2 -> sv2 this one drag to cum_column

sv2 -> sv3

i think this is help u.
by nmadhu.etl
Thu Jun 14, 2012 3:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to get cumulative sum
Replies: 14
Views: 7915

Re: how to get cumulative sum

hi,

this will get by using transformer stage.
here u can take three stage variables like sv1,sv2,and sv3.
Assign default values as 0.

sal -> sv1

sv1+sv2 -> sv2 this one drag to cum_column

sv2 -> sv3

i think this is help u.