CHAPTER 14
ETL Process Acceleration
Sometimes, getting source data to load fast into SQL Server requires a good look at the whole process. Certainly, if you can take full of advantage of all available processor cores and attempt to parallelize the load, you could shorten load times—as we saw in Chapter 13. Yet here are other aspects of ETL loads that also need to be taken into consideration if you are trying to optimize a load and ensure that the entire time taken by a job (and not just the data load) is reduced to fit into an acceptable timeframe.
In this chapter, we take a look at some of these other aspects of ETL loads, and how they can be ...
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.
