Each data model requires additional columns other than the columns requested by the solution.
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...