Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology

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 ...