SQL Files for the Dimensional Database Model

The sales_demo database illustrates a dimensional schema for data-warehousing applications. This database model alters the stores_demo schema and data. The success of the files in this section requires two prerequisites:

• You must first create a stores_demo database with the following command:

  dbaccessdemo -log

• The createdw.sql and loaddw.sql files must be in the same directory as the files with extension .unl that the loaddw.sql uses.