There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
SCD2 Inserting New Records even though nothing has changed
I'm havine an issue with the SCD2. I have a dimensions where I want to use SCD2 for any attribute field that changes. In the set up I've identified a surrogate key, business key, SCD2 Effective Date, SCD2 Expiry Date, and SCD2 Current Record. I've used the system container start time for the "now" value, granulatiry of a minute, and the last record expiry date is a varialbe stating 12/31/9999. I have used the 0 true current member, and 1 false current member. Everything else is pretty straight forward and I have used most of the defaults. The New output includes all recommended fields.
On the first run (table starts empty) all expected records load. On a second load with no changes to either the dimension or source data,all the records load again. The minute time has passed and the new records inserted are exactly the same as first record. I would expect the reocrds would go to unchanged on the second run. Any input as to why they would go to New output again?
Thanks in advance for any help.