Pages

Sunday, March 17, 2013

How to produce rows in target table with every row as sum of all previous rows in source table ? See the source and target table to understand the scenario.

SOURCE TABLE
idSal
1200
2300
3500
4560
TARGET TABLE
IdSal
1200
2500
31000
41560

  1. Pull the source to mapping and then connect it to expression.
  2. In expression add one column and make it output(sal1) and sal port as input only.
    We will make use of a function named cume() to solve our problem, rather using any complex mapping.  Write the expression in sal1 as cume(sal) and send the output rows to target.

No comments:

Post a Comment