ETL for the Data Warehouse: a Template-Driven approach

Extract, transformation, and load process development (ETL) typically accounts for more than half of the work on a Data Warehouse project. Although complex and challenging a rigorous ETL process ensures data quality and currency thus ensuring Data Warehouse credibility and usefulness. The good news is that using a standardized approach along with proven techniques and templates can exponentially lessen the amount of effort required and can ensure data quality, scalability and performance. This class gives a broad overview of ETL processing for the Data Warehouse and delves into the in-depth issues and considerations involved. The class looks at the increasing need for Real-Time data feeds to the Warehouse and discusses the various methods to meet these needs. It specifically presents and teaches a Template-Driven approach which quickens development speed and provides completeness. These templates are demonstrated with working Informatica/Oracle code, but can and have been adapted for other ETL tools and database platforms. They are also applicable for hand-coded efforts. CD's containing the code will be distributed to all class attendees.

Benefits of attending:

• Gain a thorough understanding of the critical ETL development issues
• Understand current main-stream ETL architectural approaches
• Learn in-depth techniques for addressing common development issues including how to develop near Real-Time data feeds
• Be introduced to using standardized maintenance templates and learn how to apply them to your

When is ETL for the Data Warehouse: a Template-Driven approach?

The next dates haven't been confirmed. The last edition we have on record was 14–15 Jun 2010.

Where is it held?

The last edition we have was at Visconti Palace, Rome, Italy.