This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
teaching:dw2013-w9 [2013/11/13 12:10] tcalders [Slides] |
teaching:dw2013-w9 [2013/11/27 02:05] (current) tcalders [Exercises] |
||
|---|---|---|---|
| Line 5: | Line 5: | ||
| * Transform/Cleanse | * Transform/Cleanse | ||
| * Load | * Load | ||
| - | * Data Mining | + | |
| - | * Main techniques | + | |
| - | * Classification | + | |
| - | * Clustering | + | |
| - | * Pattern Mining | + | |
| - | * Examples and applications | + | |
| ===== Slides ===== | ===== Slides ===== | ||
| * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/DW08a-TL.pdf|Slides Transform-Load]] | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/DW08a-TL.pdf|Slides Transform-Load]] | ||
| Line 18: | Line 13: | ||
| ===== 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/dates.csv|The dates source csv file]] | ||
| + | * Solutions | ||
| + | * [[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]] | ||
| + | * 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". | ||