Chapter 4. Data modeling: End to end 107
process for performing this action is to create a new physical data model, which
in turn can be utilized to create a DDL file that can be used to build the new
database.
Perform these steps to create the DDL file that represents the dimensional
logical model:
1. From within InfoSphere Data Architect, select and right-click our dimensional
logical model IND_CST_DYN_FACT.ldm to bring up the option menu. Select
Transform to Physical Data Model.
In the wizard, make sure the Create new model option is selected, then click
Next.
2. In the next panel, specify the version of DB2 or other relational database, that
will host this database structure. In our example, we use DB2 10.1. Click
Next.
3. In the final ...