SQL Saturday Precon#3 -
A Day of Enterprise Information Management - SSIS, MDS and DQS
Location: Microsoft Auditorium, EPDC2, Leopardstown
Date: Friday, 21st
Time: Registration from 9.00. Class starts at 9.30
Cost: €199 Early bird till
31st May. Full Price €249
This session is recommended for ETL developers and DBAs who have previous experience with SSIS, and a basic understanding of data warehousing concepts. While some of the design patterns will also apply to SQL Server 2008 R2, this bulk of the session will focus on capabilities available in SQL Server 2012.
Enterprise Information Management (EIM) is an industry term for technologies to manage your data for integration, quality, and governance. This full day training session will show you how Integration Services (SSIS), Data Quality Services (DQS), and Master Data Services (MDS) work together to provide a comprehensive EIM solution in SQL Server 2012. Focusing on Data Warehousing scenarios, we'll explore the key steps needed to build such a solution, from the beginning (planning, benchmarking), to data curation (cleansing, matching, managing dimensions), to data loading using SSIS. We'll also touch on some advanced data warehousing ETL design patterns, such as change data capture (CDC), slowly changing dimension processing, and automation.
- Data cleansing and matching
- Reference data managemen
- SSIS design patterns
- Incremental data loading
- SSIS deployment, management, and monitoring