Chapter 10: Operating the Data Movement Application


Overview

In this chapter, you will learn how to:

  • Load historical data

  • Use global variable and initialization file settings to load monthly data

  • Perform error checking, correct errors, and load corrected data

  • Create configurations to modify the execution of the data movement application

In this final chapter, you will operate the prototype of a data movement application to demonstrate its functionality and flexibility. You will begin by deleting the test data from the dimension, fact, staging, and auditing tables in the SBS_OLAP database and deleting all logs relating to the test data. You will then load the appropriate time records and historical data for calendar years 1996 and 1997 into the SBS_OLAP database and process that data into the Sales cube. Once the historical data is loaded, you will begin adding monthly sales data to the SBS_OLAP database and the Sales cube to exercise the capabilities of the data movement application. You will use the capabilities of the data movement application to load data from a non-default location, bypass tasks and packages for particular purposes based on configurations of global variables , verify and correct data load errors, and reload data that generated errors when it was originally loaded.




Microsoft SQL Server 2000 DTS Step by Step
Microsoft SQL Server 2000 DTS Step by Step (Step by Step (Microsoft))
ISBN: 0735619166
EAN: 2147483647
Year: 2003
Pages: 87
Authors: Carl Rabeler

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net