CHAPTER 9
Data Transformation
As we all know, the “T” in ETL stands for “transformation”. Yes, you may be able to connect to a data source, and yes, you may be able to pour data into an SQL Server destination database. Frequently, however, many changes must be applied to the data as it progresses from source to destination. Consequently, this chapter will look at some of the major data transformation challenges that face the ETL developer.
Inevitably, it is impossible to foresee every data transformation requirement and every twist and turn that data can, or must, take as it flows through an ETL process. So, equally inevitably, this chapter cannot ...
Get SQL Server 2012 Data Integration Recipes: Solutions for Integration Services and Other ETL Tools 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.
