Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012 Objective 1. Design anD impLement a Data WarehOuse Design and implement dimensions. Design and implement fact tables. 2. extract anD transfOrm Data Define connection managers. chapter Chapter 1 Chapter 2 Chapter 1 Chapter 2 Chapter 3 Chapter 4 Design data flow. Chapter 9 Chapter 3 Chapter 5 Chapter 7 Chapter 10 Chapter 13 Chapter 18 Chapter 19 Implement data flow. Chapter 20 Chapter 3 Chapter 5 Chapter 7 Chapter 13 Chapter 18 Manage SSIS package execution. Implement script tasks in SSIS. 3. LOaD.