Microsoft SQL Server 2012 Implementing a Data Warehouse: ETL Solutions
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.
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.
Designing Control and Data Flow
- describe how to design control flow in SQL Server 2012
- recognize how to implement control flow in SQL Server 2012
- recognize how to design data transformations in SQL Server 2012
- recognize how to implement advanced data flow transformations in SQL Server 2012
- implement an ETL solution using the control flow tasks and data flow components to create an SSIS project based on a scenario