This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Next revision Both sides next revision | ||
teaching:dw2013-w9 [2013/11/13 12:10] tcalders [Slides] |
teaching:dw2013-w9 [2013/11/13 12:47] tcalders [Exercises] |
||
---|---|---|---|
Line 18: | Line 18: | ||
===== Exercises ===== | ===== Exercises ===== | ||
+ | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/W8-ex/SSIS%20Update%20Exercise.pdf|ETL Update Exercise]] | ||
+ | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/W8-ex/CreateW9database-students.dtsx|the (incomplete)ETL package]] | ||
+ | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/W8-ex/createtablestatements.txt|Create table statements for the data warehouse]] | ||
+ | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/W8-ex/changes_DB_createtables.txt|Create table statements for the updates database]] | ||
+ | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/W8-ex/dates.txt|The dates source text file]] |