Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
teaching:dw2013-w9 [2013/11/13 12:47]
tcalders [Exercises]
teaching:dw2013-w9 [2013/11/27 02:05]
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 22: 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 
 +    * [[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"​.
 
teaching/dw2013-w9.txt · Last modified: 2013/11/27 02:05 by tcalders