ETL school training courses in Austin, TX (public, in-house or online)

The purpose of this course is to teach Business Intelligence (BI) professionals working in
enterprise environments to design an extract, transform, and load (ETL) solution that
supports their BI solution. Students will learn how to plan an ETL solution, and
specifically how to design and implement a SQL Server Integration Services (SSIS)
based ETL solution. They will also learn how to monitor, optimize, and deploy an SSIS
solution.

Course Objectives
At the end of the cou...

Full archival course description>>

Participants learn to load data by executing the mappings or the process flows, use Oracle Warehouse Builder 11g, Release 2 features to manage metadata changes, debug mappings, backup metadata, manage security, and tune the ETL mappings for better performance. Integration of Warehouse Builder with OBI EE, along with the Warehouse Builder architecture and configuration are discussed.

Participants learn to retrieve data from different types of sources such as flat files or relational schema...

Full archival course description>>

Tracking Efficiency in ETL Flows

•what is the platform for SAS Business Analytics?
•important concepts for SAS Data Integration Studio
•measuring efficiencies
Basic ETL Performance Tuning

•working with intermediate files
•views or physical tables for ETL flows
•data quality considerations
•transformation and column optimization
•status handling and return code check
Working with Data

•keys
•indexes
•data functions
•counting rows...

Full archival course description>>

With SQL Server 2005 release of SQL Server Integration Services (SSIS), developers will need to throw existing knowledge out of the window and be prepared to start a new. This is because the SSIS environment has progressed from existing as a side-note feature of SQL Server to becoming a new enterprise-strength Extract Transform and Load (ETL) tool.

The ability to design and develop efficient and manageable ETL processes with SSIS can lead to tremendous savings in time and effort.

T...

Full archival course description>>