Skip to Content
Former Member
Feb 08, 2012 at 07:08 PM

History Preserving updates using all the same Effective_From_Date


Now I know I'm not the only one having this issue. Two issues actually.

1. When a column changes and is recognized in the History Preserving transform, the records Active flag is set to 0 (which is fine, that's what I want) but it's Effective_End_Date is somehow changed to the same value of its Effective_From_Date.

2. When the row from Issue 1 is updated, the new Inserted row (the new active row for that key) is inserted with an Effective_From_Date of the previous records row. WHAT? Why does it do this? Why doesn't it set the Effective_From_Date to the current system time?

I'm sure that both issues are related and fixing one will fix the other. Buy why is it doing this????