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.