Wednesday, 8 May 2013


Consider the following employees data as source
employee_id, salary
10, 1000
20, 2000
30, 3000
40, 5000
Design a mapping 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
Solution:
Follow these steps,
cumulative sum
You need to give below conditions in expression transformation,
cumulative expression

17 comments:

  1. I appreciate the effort put into creating this post. It provides useful knowledge in a reader-friendly format.microsoft devops course

    ReplyDelete
  2. Great post! A MongoDB full course is an excellent way to learn NoSQL concepts, CRUD operations, aggregation pipelines, indexing, and database management. Very useful for beginners.mongodb full course

    ReplyDelete
  3. This is a helpful article with a clear message. I hope to see more informative posts on similar topics.tm1 training online free

    ReplyDelete