The "SCD2 Current Record" usage

Apr 9, 2009 at 10:44 PM
Is the SCD2 Current Record usage deprecated? I don't see it as a value in the drop-downs for the Usage column on Existing Dimension tab.

Also, there are several new ones that don't seem to be mentioned in the doc:

Audit Key for Last Change
Audit Key for Add
Audit Key for Last SCD1 Change
Audit Key for Last SCD2 Change

Am I looking at either an older doc, or maybe an older component?

I'm using KimballSCD with SQL 2005.

Apr 9, 2009 at 10:48 PM
Oops, never mind - I just found work item 1678 where these Audit columns are mentioned. I'll read some discussions here and get up to speed...
Apr 10, 2009 at 6:14 AM
I probably do have to review the documentation some...

As for the current record usage - it requires (at present) a boolean column.  So if your current record indicator is another type, that usage won't show up.  But see issue 2420 on that one...