Consider the following employees data as source:
employee_id, salary
10 1000
20 2000
30 3000
40 5000
Q1. Create a job to load the cumulative sum of salaries of employees into target table?
The target table data should look like as
employee_id, salary, cumulative_sum
10 1000 1000
20 2000 3000
30 3000 6000
40 5000 11000
https://www.beingmoneysmart.com
seqfile---->tx--->target
ReplyDeleteIn transformer stage take a two stage variables like
sv1=salary+sv2
sv2=sv1
and sv1 drag in to cumm_sal column.