GeekInterview.com
Series: Subject:
Question: 156 of 392

How to perform cummulative sum in Mapping
For eg,
Id Amt
1 10
2 20
3 30
The output should be
Id Amt
1 10
2 30
3 60

Asked by: Interview Candidate | Asked on: Oct 24th, 2007
Showing Answers 1 - 5 of 5 Answers
rajkumarger

Answered On : Dec 8th, 2007

View all answers by rajkumarger

use CUME(Amt) function

  
Login to rate this answer.
samba@galla

Answered On : Aug 25th, 2011

in,expression tranformation ,
use cum(amt) in numeric functions

  
Login to rate this answer.
Mahesh

Answered On : Jan 29th, 2012

Cumulative sal in Informtica write the expression t/r

create a variable port : v_cume_sal=v_cume_sal+sal
output port : o_cume_sal=v_cume_sal

or

function cume(sal)

  
Login to rate this answer.
kmahidar

Answered On : Jan 30th, 2012

View all answers by kmahidar

In Expression t/r
Create one variable Port v_cum_sal=v_cuma_sal+sal
output port o_cum_sal=v_cum_sal

  
Login to rate this answer.
kmahidar

Answered On : Jan 30th, 2012

View all answers by kmahidar

Create a variable port : v_cume_sal=v_cume_sal+amt
output port : o_cume_sal=v_cume_sal

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.