How to load previous salary for current row in Informatica?

Описание к видео How to load previous salary for current row in Informatica?

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
input like
employee_id, salary
10,1000
20, 2000
30, 3000
40, 5000

The output should look like as

employee_id, salary, pre_row_salary
10, 1000, Null
20, 2000, 1000
30, 3000, 2000
40, 5000, 3000

#informaticascenarios #informatica #informaticainterviews

Комментарии

Информация по комментариям в разработке

Похожие видео