Skip to Content

Flag value for old records is not getting changed

Hello,

I have updated the source record once and after running the job I found that old and new records are getting displayed as expected.

Now the same record in source is updated again so that the other 2 records get expired in target, with flag value as 'N' and updated record gets inserted in target with Flag value 'Y'.

But it is found that only once the history is preserved, after initial update all the records are having end date as future date and Flag value set to 'Y' but ideally it should be only the last record should have end date as future date while previous records should get expire.

Please advise where did I went wrong.

Thanks for your help!

Regards,

Rajan

error-06.png (87.1 kB)
error-07.png (109.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers