Every registration supports local education. TrainUp Gives Back
Logo

Your Career Training Marketplace

Questions? Call Toll-Free: 1-866-540-9677

  • Instant Access ImageInstant Access
    From Anywhere
  • Unlimited Viewing ImageUnlimited
    Viewing
  • calendar Image 6-12 Months
    To Complete

Description

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.

Learning Objectives
  • 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
  • Audience

Get the latest industry news, recommended courses, & promotions from TrainUp.com sent straight to your inbox.