Adding Standard columns to your data model
Each data model requires additional columns other than the columns requested by the solution.
Getting ready
Identify your dimensions and facts within your data model.
How to do it...
Tracking changes in a BI data model is a little different to a standard database application. In the BI data model, we track the process which created or updated the database and not the actual user:
1. For facts and dimensions, we will want to track when changes were made and by whom. For this, we need to add the standard audit columns. Double-click on the entity, select Attributes, and add the following columns:
Create By — Domain — Varchar 32 Characters — specifies which process or mapping created the record.
Create Date — Domain — Date — specifies the date the record was created.
Update By — Varchar 32 Characters — specifies which process or mapping updated the record.
Update Date — Date — specifies the date the record was updated.
2. Additional attributes to track...
