Advertisement

Data Warehouse Patterns

  • Andy Leonard
  • Tim Mitchell
  • Matt Masson
  • Jessica Moss
  • Michelle Ufford
Chapter

Abstract

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.

Keywords

Design Pattern Incremental Load Separate Package Table Cache Dimension Record 
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.

Copyright information

© Andy Leonard 2014

Authors and Affiliations

  • Andy Leonard
    • 1
  • Tim Mitchell
    • 1
  • Matt Masson
    • 1
  • Jessica Moss
    • 1
  • Michelle Ufford
    • 1
  1. 1.VAUnites States

Personalised recommendations