Overview/Description
ETL, extract, transform, and load, is the main process in data warehousing solutions. It facilitates the transfer of the data from a source to a destination, which may also evolve transforming the data during the process. This course discusses the ETL process and how it can be implemented and demonstrates how to create simple SSIS packages that use the Data Flow Task in SQL Server Data tools, SSDT. During the demonstration, how to use connection managers to specify the source and destinations for the data is also covered, as well as how to use other tasks to transform the data before it is extracted. 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.
Target Audience
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.