This class provides comprehensive technical training for IT professionals using Warehouse Builder on Showcase 9.
This class emphasizes the creation of data distribution definitions and the creation and execution of distribution sets for building a relational data warehouse. The use of a star schema structure to define the data warehouse definition is explained. Lab exercises are included to reinforce the learning experience.
Who Should Attend
This class is intended for IT professionals with prior experience in iSeries relational database architecture. The class content presents information from an Information Technology perspective.
A background in Information Technology and experience with relational database file structures, Structured Query Language (SQL) and Microsoft Windows based applications is required. Experience with either Showcase Query or Report Writer is strongly recommended.
What to Expect
- Introduction to Warehouse Builder
- Building a Relational Database
- Designing a Star Schema
- Additional Features of Warehouse Builder
- Using Non-DB2 Data Sources