In this recipe, we will create a Data Source and minischema for the ASOsamp application. We will also set up joins for tables that have a recursive relationship, and identify the dimensions, attributes, and fact tables in our model. Finally, we will review why the ASO model is a good choice for the ASOsamp application.
To get started, open
SQL Server Management Studio, and add a database called ASOsamp
. We are using the SQL Server scripts in this example, but Oracle PL SQL scripts are available as well.
Open up SQL Server Management Studio, click on the ASOsamp database, click on the File menu, select Open, and click on File ….
Open the script,
3265_04_01tsql.sql
.Make sure that ASOsamp is selected in your Available Database window.
Click on Execute.
Click on the File menu, and then on Open, and click on File…. Open the script
3265_04_01_sampledata.sql
.Make sure that ASOsamp is selected in your Available Database window...