DSXchange

source
id,sal
10,1000
20,2000
30,3000
40,5000

target:
id,sal,cum_sum
10,1000,1000
20,2000,3000
30,3000,6000
40,5000,11000

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.

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.

k its working.i did one small mistake

Then you're not doing it right. Show us exactly what stage variables you are using, how each is initialized and how each is derived as each row is processed.

Take two stage variable S1 and S2.. Initialise both to zero.

Use below logic.

SAL+S1 => S2 ( Map S2 to cumu_column)
S2 => S1

And make sure you execute transformer in sequential mode.

No need of S3.
Also records need to be sorted by by ID

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

if st1 is null then SAL else st1+SAL--------st1

(OR)

if @inrownum=1 then SAL else st1+SAL--------st1


map st1 to sumcolum

make sure the data should be sorted based on SAL

sv1+sv2->sv2
or
sv1+sv3->sv2 both are working fine..

So... resolved?

without transformer can we do this scenario?

both are also working good.

ntr wrote:if st1 is null then SAL else st1+SAL--------st1

(OR)

if @inrownum=1 then SAL else st1+SAL--------st1


map st1 to sumcolum

make sure the data should be sorted based on SAL

I would not say it is impossible, but all solutions without a Transformer are beyond Your experience level. Leave it at that.

jhansi wrote:without transformer can we do this scenario?

Is this an interview question?

Why do you want to do it without a Transformer stage?

It used to be the case that the Transformer stage was inefficient but they did a lot of work to it (version 8.1.x ?) and that advice is no longer correct.