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?
Printable View
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?
Hi,
SRC ---> EXP ---->[use CUME function to get the running total] ------>AGG----->TAR
Thx,
Prakash