Scenario: 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.
- Pull the source to mapping and then connect it to expression.
- 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.