SQL files for the Dimensional Database Model

You can implement a dimensional database for data-warehousing applications by running scripts that create the sales_demo database.

The sales_demo database is based on the stores_demo schema and data.

To create the sales_demo database:

  1. Create a stores_demo database with the following command:
    dbaccessdemo -log
  2. Make sure that the createdw.sql and loaddw.sql files are in the same directory as the files with extension .unl that the loaddw.sql uses.
  3. Run the createdw.sql file.
  4. Run the loaddw.sql file.

Copyright© 2018 HCL Technologies Limited