
Chapter 4. Data modeling: End to end 97
4.3.1 A starting point: The physical data model
Here we aim to create a logical data model of the target OLAP data warehouse
by first creating a physical data model of the OLTP production database. In our
example, this is a physical data model of the IWHPRD82 database on our lab
systems. It is worth noting that you can, as an alternative, always start with a new
blank logical data model in InfoSphere Data Architect.
To start this process, perform these steps:
1. Start InfoSphere Data Architect and create a workbench storage area, if one
has not already been assigned.
2. Create a new Data Project to store ...