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?
Does not seem to handle inferred members correctly
I have a dimension with mostly SCD2 and one SCD1 column. During a deployment I had a need to add some columns to the dimension table so I set Inferred true on all records as I copied the data into the new table expecting it to update the new columns. But
after a run it behaved as if the update was SCD2 and inserted all new rows, however, it did not clear the "CurrentRow" on the existing inferred rows.
It was my understanding that an Inferred member makes all SCD2 columns SCD1. I also noticed that InferredMember is "Optional" on the SCD1 output. This does not seem correct since inferred rows should be updated by "Updated SCD1" and the
Inferred flag would need to be reset at this point.
Am I misunderstanding how inferred is supposed to behave is is there a bug?