3-day course
For those that have completed our Introduction to ETL and Data Acquisition course, or for ETL programmers, IT designers and developers, DW administrators, technical business users and others with a solid understanding of ETL processes, this 3-day program will elevate their ETL skills to a whole new level of technical excellence.
What You Will Learn:
- Source-to-target data identification, sourcing and mapping – best practices
- ETL concepts – architecture phases, data structures, data replication, process-flow management, parallelism, performance, optimization, etc.
- ETL techniques – record layouts, stream processing, continuous processing, local keys, changing dimensions, code tables, data cleansing, aggregations, unit tests
- Managing ETL schedules, timing of extracts, frequency of database loads
- Metadata management
- Smart ETL designs - implementing business rules into ETL processes
- Overview of key ETL vendors and products
- Hands-on exercises and breakout sessions
Benefits of Attending:
- Interactive nature of program will reinforce conceptual teachings
- Gain a solid understanding of the requirements for placing ETL processes into a robust and scalable production environment
- Advance your hands-on skills through a series of exercises and breakout sessions
For more details, e-mail training@adastracorp.com or call 905-881-7946.