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
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
Write a review
