Chapter 5. Designing and Implementing Data Flow
Exam objectives in this chapter:
Extract and Transform Data
Design data flow.
Implement data flow.
The previous chapter covered control flow tasks that orchestrate the whole extract-transform-load (ETL) process. This chapter looks at the most important control flow task—the data flow task, which is a crucial component in the data warehouse project for ETL operations. All the components in a data flow task operate on rows of data. You can group the elements of the data flow task into three categories: data source adapters, data destination adapters, and data transformations. This chapter shows you how to create data flow tasks and use an appropriate ETL strategy.
Lessons in this chapter:
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.
