Facebook

ETL Design Techniques

* Looking for a flexible schedule (after hours or weekends)? Please call 858-208-4141 or email us:  sales@ccslearningacademy.com.

Student financing options are available.

Transitioning military and Veterans, please contact us to sign up for a free consultation on training and hiring options.

Looking for group training? Contact Us

psinghal
Last Update October 30, 2023
0 already enrolled

About This Course

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

Your Instructors

psinghal

0/5
472 Courses
0 Reviews
0 Students
See more

Write a review

#edumall-wp-widget-courses-1 { display: none; } #single-course-ratings { display: none; } .tutor-single-course-lead-meta { display: none; } .lead-meta-item meta-course-total-enrolled { display: none; }