Overview/Description
To create complex ETL solutions you can use control flow and data flow. Control flow consists of three elements: containers, tasks, and precedence constraints, which can be used to provide structure, functionality, and order of operations in the control flow. By using the control flow Data Flow Task, data flow can be implemented into the SSIS package to specify the source of the data, how the data should be transformed, and then the data destination. This course discusses and show how to design and implement the control flow elements. It also explains the different types of transformations to transform the data and how to implement them on the data that is extracted for the source. 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 loading data as part of an ETL solution, and data cleansing.