Mapping scenario

[tanya_j]

My source data is a flat file and it has empid, deptid and 12 columns for salaries of each month (jan-dec).
Now my requirement is to create one record for each month and also running total of the salary.
What type of transformations should be used?

[cme_prak]

Hi,

SRC ---> EXP ---->[use CUME function to get the running total] ------>AGG----->TAR

Thx,
Prakash