This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
teaching:dw2013-w9 [2013/11/26 23:17] tcalders [Exercises] |
teaching:dw2013-w9 [2013/11/27 02:05] tcalders [Exercises] |
||
---|---|---|---|
Line 17: | Line 17: | ||
* [[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/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/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]] | + | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/dates.csv|The dates source csv file]] |
* Solutions | * Solutions | ||
* [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/UpdateNorthwind.dtsx|SSIS Package]] | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/UpdateNorthwind.dtsx|SSIS Package]] | ||
* [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/SSIS-Update%20Exercise%20Solution.pdf|Solution Explanation]] | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/SSIS-Update%20Exercise%20Solution.pdf|Solution Explanation]] | ||
- | * On the database server, a database with some example updates has been made avaailable for testing purposes. The name of this database is "W9-updatesNorthwind". | + | * On the database server, a database with some example updates has been made available for testing purposes. The name of this database is "W9-updatesNorthwind". |