Byron Employment

Byron Employment. Over 71,594 Jobs Australia Wide.

Delivery Method

  • Classroom
  • Price: $3250.00

Course Overview

2092 Populating a Data Warehouse with Microsoft SQL Server 2000 Data Transformation Services 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 ServerT 2000.

Delivery

Classroom

Duration

5 Days

Locations

  • Public Schedule - Perth and Sydney
  • Group Bookings - all States and Territories across Australia

Outline

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
     

Lunch

Lunch is provided for students for the duration of the course

CLICK HERE TO BOOK THIS COURSE NOW!

WANT MORE INFORMATION?
CALL NOW ON (02) 8263 5906
CLICK ON THIS LINK TO ENQUIRE!

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL (02) 8263 5906 OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search