ETL Design Techniques
This course focuses on extract, transform, and load techniques to populate dimensional models.
Student financing options are available.
Transitioning military and Veterans, please contact us to sign up for a free consultation on training and hiring options.
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).
- Manage ETL strategies
- Perform initial and incremental loads
- Learn incremental load, CDC, CheckSum, and Time Stamp techniques
- Perform data profiling, cleansing, validation, and verification