SQL Server Integration Services (SSIS) is an extensible platform for creating data integration and workflow solutions. SSIS is extensible because developers have the ability to create custom components if the integrated components do not suit their needs. In this course we cover how to develop and install custom components and implement script tasks. Also discussed are the different types of Slowly Changing Dimensions (SCD), and how to manage data that slowly changes over time. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft SQL Server 2012 exam 70-463:Implementing a Data Warehouse with Microsoft SQL Server 2012. This exam is one of the requirements for the MCSA: SQL Server 2012, MCSE: Data Platform, and MCSE: Business Intelligence certification paths.
Data Warehouse Developers and Database Administrators who create and manage business intelligence solution as part of their daily tasks, which include implementing data warehouse databases, extracting transforming, and extracting data as part of an ETL solution, and data cleansing.
Microsoft SQL Server 2012 – Implementing a Data Warehouse: Custom Components
- describe how to use scripting components in SQL Server 2012 SSIS
- identify the planning considerations for custom components in SQL Server 2012 SSIS
- describe how to manage data that slowly changes over time
- implement the custom components and handle slowly changing dimensions in SQL Server 2012 SSIS