2092 - Populating a Data Warehouse with Microsoft SQL Server 2000 Data Transformation Services
Duration: 5 Days.
Prerequisites:
Before attending this course, students must have:
- Familiarity with Microsoft SQL Server version 7.0 or Microsoft SQL Server 2000
- Course 832,System Administration for Microsoft SQL Server 7.0, and Course 833,Implementing a Database on Microsoft SQL Server 7.0, or the equivalent Microsoft SQL Server 2000 courses
- Knowledge of Transact-SQL usage in the development of online transaction processing (OLTP) systems
- Basic understanding of programming principles (especially experience with a scripting language such as Microsoft Visual Basic Scripting Edition development software)
- Understanding of basic database design, administration, and implementation concepts
Course Description:
This course provides students with the knowledge and skills necessary to design a data warehouse and to populate data marts by using Data Transformation Services (DTS) in Microsoft SQL Server 2000
Objectives:
Understand data warehousing concepts and applications
Build relational data marts by using star schemas
Develop a data warehouse data load strategy
Use the DTS Import/Export Wizard
Understand DTS package components
Use DTS to copy and manage data
Design insert based transformation by using the Transform Data Task
Implement a Data Driven Query solution
Execute packages and design package security
Understand the basics of the DTS Object Model
Modify DTS package properties
Implement DTS in specific real-world data load scenarios
Apply tuning techniques to DTS data loads
Lesson 1: Using DTS in a Data Warehouse
Defining Data Transformation Services
Identifying DTS Applications
Defining the Data Warehouse System
Applying DTS to the Data Warehouse
Lesson 2: Defining Data Warehouse Structures
&n