Just knowing how to use SSIS is often not enough when faced with challenging processing requirements or complicated environments. This course takes IT professionals, DBAs and developers to a deeper level of SSIS skills maturity. By the end of the seminar, students will have the knowledge on how to architect SSIS solutions and deal with advanced requirements for data cleansing and data warehousing.
This course is intended for solution architects, DBAs, and developers who work with SSIS and are responsible for ETL for high performance data warehousing or data architecture planning.
While based on SQL Server 2008 R2, the course is equally applicable to those working with SQL Server 2005, SQL Server 2008 & 2012 Differences in the versions will be highlighted.
- Introduction to dimensional modelling
- SSIS Control Flow & Data Flow
- High Performance Dimension and Fact table load with type 2 changes
- Advance SSIS loads
- SSIS deployment and management