Advanced Data Warehouse Workshop: Extract, Transform and Load  (DW130)

Extract, Transform, and Load (ETL) is the most commonly accepted architectural model for Data Warehouse data acquisition, movement, and manipulation. However, many implementors have discovered through trial, that a simplified ETL approach is inadequate for complex enterprise and Very Large Database (VLDB) Data Warehouse implementations. ETL alone is insufficient when considering the many heterogeneous sources, real-time complex transformation and cleansing requirements, and populating many diverse Online Analytical Processing (OLAP) schemas all common in even the simplest of warehouses. These complexities combined with the fact that a single tool or program module cannot provide all the function required for your warehouse, lead implementors to build unmanageable systems comprised of many independent tools and hand coded programs. Learn how to avoid the unmanageable. Complete classroom exercises to learn practical approaches, tools, and techniques required for building the Data Warehouse populating subsystem, which is responsible for all acquisition, movement and transformation of data into the Data Warehouse and throughout its components. Course content considers both one and two-tiered VLDB data warehouse architectures, which makes this course suitable, whether you are involved in building corporate-wide VLDB data warehouses or are dealing with VLDB issues for large data marts. Considerations for low latency real-time or active data warehouses is also included. The majority of the time in this course is spent on exercises and case studies. Review and evaluate Architected solution models for VLDB and standard Data Warehouse populating subsystems. Map these solution models onto techniques and commercially available software tools for: