Prerequisite: An understanding of relational database and DW terms and concepts

HandsOn-ETL™ is committed to providing a non-biased lecture on best-of-class technologies and techniques as well as exposing participants to leading ETL tools, their use, and their application. The course begins with an examination of data and technical architectures specific to ETL. Participants are then led through discussions and lab exercises that emphasize product features, functionality, and applicability of products such as: DataStage, SAS, SyncSort, and MS DTS.

This course is designed to provide participants with an opportunity to compare and experience critical features of leading ETL tools. In a formal lab setting, students will use three tools for extracting, transforming, cleansing, and loading raw source data into a target star schema. Extensive lab time provides students with valuable insight into the features of each product and how they may fit in their warehouse efforts.

HandsOn-ETL™ is designed to provide participants with a non-biased view of leading ETL tools.

You will learn:

• The best practices, in both data and technical architectures, for implementing a successful extraction, transformation, and loading process
• The core components to effective ETL processes
• Through extensive lab exercises, you will gain hands-on experience with leading ETL tools, including:
  • Ascential Software’s DataStage
  • SAS ETL Technology
  • MS Data Transformation Services
  • SyncSort
  • Other (the combination of products is based on availability)
• How and when to effectively apply leading ETL tools
• To compare and contrast ETL features in order to make the best decision for your organization

Intended Audience

• Anyone involved in the design and construction of extraction, transformation, and loading of a DW

Please note that enrollment is limited to 30 attendees

     Course Outline>