Skip to Content
0

Flag value for old records is not getting changed

Jan 09, 2017 at 12:09 AM

39

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers