Chapter 9. Meta Integration of DB2 Cube Views within the enterprise toolset 383
Figure 9-55 Transform to data model option
Figure 9-56 Transforming an object model into a data model in Rose
2) Using Rose, generate the SQL DDL
Once the model has been designed, the SQL DDL can be generated and the
database created in DB2 UDB as shown in Figure 9-57.
384DB2 Cube Views: A Primer
Figure 9-57 Generation of the SQL DDL in Rose
3) Using DB2, create the tables and columns of the database
This script can be executed to create the DB2 Tables using the DB2 Command ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.