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 ..
very nice information. Thanks you for you post bloggers or Totally inspirational.
ReplyDeleteVisit this page
You post is like immunity booster for bloggers.
ReplyDeletelook at here more info
nice read
ReplyDeleteThanks for sharing this: r programming language course
ReplyDelete