Flag column in History Preserving is not giving set value

dataservices job design
1

At first I updated source record and ran the job, the updated record in source was set to insert in target and Flag value changed as ‘y’ for updated record having end date as future date and previous record Flag changed to ‘n’ with end date = start date.
But when again I changed the source value, history is getting preserved that record but Flag value is remaining same i.e., ‘y’ for this new update.
Also end date value for both updated records are future date but ideally it should not happen.
Please correct me where did I went wrong.

Thanks in advance!! :slight_smile: [/img]

Raj16 (BOB member since 2017-01-09)

2

Hi Raj,

I guess u need to use the key generation transformation for not duplicating the primary keys.

Also, you need to set the start date and end date parameters propelry while designing the jobs.

Regards,
Prasanna

prsnry (BOB member since 2016-12-13)