Srinivasan Software Solutions Blog 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..!!

>> In my source table am having sal, I need to display 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..!!   >> We can achieve this by creating procedure , Find below the tasks created Drop table Create table as below … Insert Records In source command : mention  like below.. (We can achieve our requirement by LAG function)   In The target command insert records like below… >> Created Tasks as per requirement …. >> save and execute ..