Implementing a Data Warehouse with Microsoft SQL Server 2012: Dynamic Packages

  • 12/15/2012

Suggested Practices

To help you successfully master the exam objectives presented in this chapter, complete the following tasks.

Use a Parameter to Incrementally Load a Fact Table

In order to practice what you have learned in this chapter, you will create a package to load a fact table that will store Internet sales data based on the AdventureWorks2012 database.

  • Practice 1. Create the necessary package to load the fact table. At each execution of the package, do the full load and truncate the table at the beginning.
  • Practice 2. Add a project parameter that will accept the incremental date and use it to load only data that is newer than the supplied value. Replace the TRUNCATE T-SQL statement at the beginning with the DELETE T-SQL statement.
  • Practice 3. Parameterize all connection strings.