October 18, 2012, 03:54 PM
ChiranjeeviEnd 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
ClifThe 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.