
Chapter 9. Meta Integration of DB2 Cube Views within the enterprise toolset 353
Forward engineering from ERwin v3.x to DB2 Cube Views
The goal of this scenario is to demonstrate how an existing ERwin model can be
converted to a DB2 cube model.
The overall process of this metadata conversion is as follows:
1. Using ERwin, create the star schema model.
2. Using ERwin, generate the SQL DDL for this database.
3. Using DB2, run this SQL script to create the tables and columns of this
schema.
4. Using ERwin, save the model as ERX.
5. Using MIMB, convert this ERwin ERX file into a DB2 Cube Views XML file.
6. Using DB2 Cube Views, import this DB2 Cube Views ...