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
Search found 3 matches
- 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
- 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.
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.
- 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.
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.