Lesson 1: Using DTS in a Data Warehouse
The following topics are covered in this module:
Defining Data Transformation Services
Identifying DTS Applications
Defining the Data Warehouse System
Applying DTS to the Data Warehouse
|
|
Lesson 2: Defining Data Warehouse Structures
The following topics are covered in this module:
Defining the Polaris Data Warehouse
Identifying Source and Destination Structures
Defining Dimension Tables
Defining Fact Tables
Implementing the Star Schema
|
Lesson 3: Populating Data Warehouse Structures
The following topics are covered in this module:
Reviewing the Star Schema Data Load
Defining the Dimension Data Load
Defining the Fact Table Data Load
Implementing Staging Tables
Applying Data Transformation Services
Using DTS to Populate the Sales Star
|
Lesson 4: Using the DTS Import/Export Wizard
The following topics are covered in this module:
Defining the Import/Export Wizard
Copying Objects Between Heterogeneous Databases
Copying Tables from Microsoft Access 2000 to SQL Server
Creating a Prototype Package
Loading the Employee_dim Dimension
Loading the Product_dim Dimension
|
Lesson 5: Understanding DTS Package Elements
The following topics are covered in this module:
Learning Package Components
Using DTS Package Designer
Defining Package Connections
Defining Package Tasks
Defining Package Steps
Storing and Executing Packages
Adding a Parallel Data Load to Product_dim
|
|
Lesson 6: Copying and Managing Data
The following topics are covered in this module:
Identifying DTS Tasks That Copy and Manage Data
Using the Bulk Insert Task
Loading Staging Tables
Using the Execute SQL Task
Using the Copy SQL Server Objects Task
|
Lesson 7: Performing Data Transformations
The following topics are covered in this module:
Performing Transformations in DTS
Defining the Transform Data Task
Setting Up the Source and Destination
Creating Transformations
Configuring Error Handling
Optimizing for SQL Server Destinations
|
Lesson 8: Extending Transformations
The following topics are covered in this module:
Building Microsoft ActiveX?? Script Transformations
Creating Advanced Transformations
Using Lookup Queries
Implementing SQL Solutions
Using the Multiphase Data Pump
|
Lesson 9: Implementing Data Driven Query Solutions
The following topics are covered in this module:
Using the Data Driven Query Task
Building a Data Driven Query Task Solution
Maintaining Slowly Changing Dimensions
Refreshing the New_product_dim Table
Learning Best Practices for the DDQ
|
|
Lesson 10: Storing DTS Packages and Metadata
The following topics are covered in this module:
Understanding Package Versions
Storing DTS Packages
Securing DTS Packages
Storing Metadata
Tracking Data Lineage
|
Lesson 11: Executing Packages
The following topics are covered in this module:
Defining Package Executions
Executing Packages Interactively
Using Package Execution Utilities
Creating Package Execution Logs
Executing Moduleal Packages
Scheduling Packages
|
Lesson 12: Managing Package Properties
The following topics are covered in this module:
Reviewing DTS Package Elements
Understanding Disconnected Edit
Using the Dynamic Properties Task
Managing Connection Properties
|
Lesson 13: Building Advanced Workflows
The following topics are covered in this module:
Implementing Asynchronous Workflows
Implementing Package Transactions
Creating a Package Loop
|
|
Lesson 14: Applying Best Practices
The following topics are covered in this module:
Defining the Data Load Scenario
Developing Packages
Choosing Tasks
Designing Transformations
Defining Workflows
Storing and Executing Packages
Managing Packages
|
Lesson 15: Case Study - Populating the Shipments Star
The following topics are covered in this module:
Defining the Shipments Star
Populating the Shipments Star
Migrating the Shipments Star
|
|
|
| Top |
|