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

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.