Designing SSIS Integration Solutions
SQL Server Integration Services (SSIS) is a flexible feature in SQL Server that supports scalable, high-performance extract, transform, and load (ETL) tasks. This course will teach you best practices for the design of an SSIS ETL solution.
What you'll learn
Business intelligence solutions often require data sources to be transformed into dimensional model structures that are better suited for reporting and analysis than operational data structures. After the design of a dimensional model is complete, the next step is to design extract, transform, and load (ETL) processes. In this course, Designing SSIS Integration Solutions, you’ll learn how to analyze, organize, and document requirements for an ETL solution to be implemented in SSIS. First, you’ll explore tools and techniques for translating business requirements into ETL requirements and ensure best practices are applied. Next, you’ll discover how to design the data integration workflow for common ETL tasks in SSIS. Finally, you’ll learn about other best practices to incorporate into your SSIS packages for optimal performance and security. When you’re finished with this course, you’ll have the skills and knowledge of SSIS design needed to successfully plan for the development of your own ETL solutions.
Table of contents
- Documenting ETL Requirements 2m
- ETL Summary 2m
- Standards 2m
- ETL Architecture 2m
- Auditing and Logging Mechanism 3m
- System Availability Requirements 2m
- Process Standards 6m
- Extraction Framework 3m
- Slowly Changing Dimension Handling 4m
- Business Rules and Notifications 2m
- Job-level Details 3m
- Job Diagram 3m
- Reference Documentation 2m
- Late-arriving Data Handling 2m
- Summary 2m
About the author
Stacia Misner Varga is an instructor, author, and principal consultant of Data Inspirations. Her career spans more than 30 years, with a focus on improving business practices through technology. Since 2000, she has provided consulting and education services for Microsoft’s data platform and authored or co-authored many books covering this topic. In addition, Stacia has been a frequent speaker over the years at technology conferences worldwide.