|
|
|
By defining how to build DTS packages that populate star schemas, presenting how to execute and save these packages, showing how to manage DTS packages, and presenting best practices for designing DTS packages, students will gradually achieve a complete and correct understanding of how to use DTS to address various data load scenarios. Module 1 - Using DTS in a Data Warehouse: Introduces students to the functionality of DTS and how DTS applies to the data warehouse system. This module narrows the scope of the data warehouse system, providing definitions of data warehouse components and technologies that will be covered in this course. Module 2 - Defining Data Warehouse Structures: Defines the specific data warehouse that you will use in this course, the polaris data warehouse. This module uses the polaris data warehouse to identify star schemas, dimension tables, and fact tables. This module serves two primary purposes: provide a common definition of key data warehousing terms and familiarize students with the polaris data warehouse. Module 3 - Populating Data Warehouse Structures: Teaches the fundamentals of using DTS to populate star schemas. This module presents techniques to populate dimension tables and fact tables in addition to techniques to facilitate the data load process by using staging tables. To implement the data loads, this module describes how to apply DTS by defining DTS packages and identifying package components.
|
||