Data Warehouse Patterns
Andy Leonard, Tim Mitchell, Matt Masson, Jessica M. Moss, Michelle Ufford · Apress eBooks · 2014
SQL Server Integration Services is an excellent all-purpose ETL tool. Because of its versatility, it is used by DBAs, developers, BI professionals, and even business principals in many different scenarios. Sometimes it’s a dump truck, used for the wholesale movement of enormous amounts of data. Other times it’s more like a scalpel, carving out with precision just the right amount of data. These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.