Database Reference
In-Depth Information
Moving On
We could easily devote more time to ETL programming, but we would like to take some time to demonstrate how
these statements are utilized in conjunction with the SSIS. So, let's move on from here and create an SSIS project
for the ETL processing needed in the DWPubsSales data warehouse. We use the SQL statements you created in
this chapter to do so. Chapter 7 shows you how easy it is to combine SQL programming statements and SSIS tasks
to create effective ETL projects.
LearN BY DOING
in this “Learn by Doing” exercise, the process defined in this chapter is performed using the northwind
database. we have included an outline of the steps you performed in this chapter and an example of how the
authors handled them in two word documents. These documents are found in the folder
C:\_BISolutionsBookFiles\_LearnByDoing\Chapter06Files
. Please see the
ReadMe.doc
file for detailed
instructions.
What's Next?
he purpose of this topic is to describe the process of creating a professional BI solution in conjunction with SQL
Server 2012. We have provided simple SQL code examples that allow readers to get an idea of how this code can
be used as part of the ETL process. If you are a beginning SQL programmer, you may want to devote some time to
improving your SQL skills. We suggest you check out a free tutorial on the W3 Schools website at
http://www.w3schools.com/sql/default.asp
.
A book that we have found to be both fun and informative on
SQL programming is
Beginning Microsoft SQL Server 2008 Programming
by Robert Vieira (Wrox, 2009).
