Focal Point
End date is not updated in SCD1 logic

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/8917082526

October 18, 2012, 03:54 PM
Chiranjeevi
End date is not updated in SCD1 logic
Hi ,

I have given SCD1 for necessary columns and given Begin Date and End Date also.

Whenever new rows are inserting , Begin Date is working fine but if update happens End date is not loading any dates.

Please let me know solution for this.

Thanks,
Chiranjeevi A.
October 19, 2012, 09:56 AM
Clif
The default end date for active records is NULL. Is that your issue? If so you can override it by setting a global variable documented in the Users Guide. Most users prefer a date far in the future such as 12/31/2199.

If it's something else it might be best to open a hottrack case and upload your synonyms and flows.


N/A