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.