Database Reference
In-Depth Information
Now that you have learned about the common dimensional design patterns, it is time to use your knowledge
by performing the following exercise.
eXerCISe 4-1. reVIeWING the DWpUBS Data WarehOUSe
in this exercise, you review a data warehouse design for the Pubs database using the design created by the
authors.
once again, there is not much to do in this exercise, but we did not see the point in having you fill in the
spreadsheet line by line when reviewing and decided it would be just as enlightening and less tedious if we
did it for you. However, in the “Learn by Doing” exercise of this chapter, you indeed get this type of practice.
Here are the steps to follow:
1.
open the
PubsBISolutionworksheet.xslx
file found in the downloadable book
files.
2.
navigate to the data warehouse worksheet and compare the tables listed to the
designs presented in this chapter.
3.
Review the columns and datatypes defined in this worksheet comparing the original
source datatypes to the destination datatypes. Figure
4-24
is an example of what
this worksheet looks like, but the details will be more visible in the worksheet itself.
(You create these tables in the next chapter, and details are provided there as well.)
Figure 4-24.
The PubsBISolution data warehouse worksheet
