Chapter 7. Enhancing Data Flow
Exam objectives in this chapter:
Extract and Transform Data
Design data flow.
Implement data flow.
Load Data
Implement data load options.
In Chapter 5 you learned about the data flow task, which is a crucial component in data warehouse projects when it comes to extracting, transforming, and loading data (ETL). Building on the foundation laid in that chapter, this chapter focuses on specific solutions for common data warehouse problems such as managing Slowly Changing Dimensions (SCD) and loading incremental data.
Lessons in this chapter:
Before You Begin
To complete this chapter, you must have:
Basic knowledge of Microsoft ...
Get Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft SQL Server 2012 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
