In the data warehouse, there is one indicator for gender—m and f. In the data warehouse,
there is one unit of measurement—centimeters. The transformation from application data
to corporate data is made during the ETL process.
The diagram in Fig. 12.1.8 is a good illustration of what is meant by the difference
between application data and corporate data.
A fundamental concept to the integrity of data and the establishment of corporate data is
the “system of record.” The system of record is the definitive data of the corporation. In
the operational environment, the system of record is the data that feed values to the data
warehouse.
Fig. 12.1.9 illustrates the system of record in the operational environment.
Fig. 12.1.9 The system of record in the operational environment.It is worthwhile noting that the system of record moves from one environment to the
next. The system of record for operational data resides in the operational environment.
Chapter 12.1: Operational Analytics