Can DM create SCD type2 dimensions?

[larus]

Is there a possibility to create slowly changing dimensions (type 2) using Data Manager?

[wyconian]

Yeah

There are a couple of ways of doing it, you can get the dimension builds to track changes and add effective to/from dates to a record (I think that's a property on the actual fact build).  Or you can do it manually using some kind of a delta load and manually adding effective to/from dates.

[MFGF]

Dimension Builds inherently support both Type 1 and Type 2 changes. When using the Dimension Build Wizard, all you need to to is to check the option to use surrogate keys and the option to track changes. On the next page, set the "Track" checkbox on for any columns you wish to perform Type 2 changes for, and leave the checkbox empty for any columns you want to do Type 1 changes for.

If you are creating the dimension build manually, you need to add the relevant attributes and behaviours to handle change tracking in the output template.

Cheers!

MF.