Using the Web material

---

The additional Web material that accompanies this redbook includes the following files:

File name	Description
SG246080.zip	Zipped SQL statements and report samples

System requirements for downloading the Web material

The following system configuration is recommended:

Hard disk space:	1 MB
Operating System:	Windows/UNIX
Processor:	700 or higher
Memory:	256 MB or more

How to use the Web material

Create a subdirectory (folder) on your workstation, and unzip the contents of the Web material zip file into this folder.

The files in the zip archive are:

trade_petstore_method-avg.rpt	A sample Crystal Report file showing how to report on aggregated average data collected from TWH_CDW.
trade_petstore_method-max.rpt	A sample Crystal Report file showing how to report on aggregated maximum data collected from TWH_CDW.
cleancdw.sql	The SQL script used to clean ITMTP source data from TWH_CDW.
resetsequences.sql	The SQL script used to reset the ITMTP source ETL process.

---