ETL Design Techniques

Start Date: January 01, 1970 – 12:00 AM (Pacific Time)

End Date: January 01, 1970 – 12:00 AM (Pacific Time)

This course focuses on extract, transform, and load techniques to populate dimensional models.

Category:

Download PDF of Course Details

Course Description

This course focuses on extract, transform, and load techniques to populate dimensional models. Students will be introduced to multiple ETL initial and incremental load techniques (including, but not limited to: checksums, CDCs, and timestamps) to effectively load data into a data warehouse/data mart. Additionally, students will be exposed to real-time problems that occur while performing ETL, including multiple data operations (such as data profiling, data cleansing, and data verification).

 

Learning Objectives

  • Manage ETL strategies
  • Perform initial and incremental loads
  • Learn incremental load, CDC, CheckSum, and Time Stamp techniques
  • Perform data profiling, cleansing, validation, and verification

 

Hours

25