SQL Server 2012 Integration Services Design Patterns (Paperback)

Andy Leonard, Matt Masson, Tim Mitchell, Jessica M. Moss, Michelle Ufford

  • 出版商: Apress
  • 出版日期: 2012-09-04
  • 售價: $2,330
  • 貴賓價: 9.5$2,214
  • 語言: 英文
  • 頁數: 456
  • 裝訂: Paperback
  • ISBN: 1430237716
  • ISBN-13: 9781430237716
  • 相關分類: MSSQLSQLDesign Pattern
  • 海外代購書籍(需單獨結帳)

買這商品的人也買了...

商品描述

SQL Server 2012 Integration Services Design Patterns is a book of recipes for SQL Server Integration Services (SSIS). Design patterns in the book show how to solve common problems encountered when developing data integration solutions. Because you do not have to build the code from scratch each time, using design patterns improves your efficiency as an SSIS developer. In SSIS Design Patterns, we take you through several of these snippets in detail, providing the technical details of the resolution.

SQL Server 2012 Integration Services Design Patterns does not focus on the problems to be solved; instead, the book delves into why particular problems should be solved in certain ways. You'll learn more about SSIS as a result, and you'll learn by practical example. Where appropriate, SQL Server 2012 Integration Services Design Patterns provides examples of alternative patterns and discusses when and where they should be used. Highlights of the book include sections on ETL Instrumentation, SSIS Frameworks, and Dependency Services.

  • Takes you through solutions to several common data integration challenges
  • Demonstrates new features in SQL Server 2012 Integration Services
  • Teaches SSIS using practical examples

What you’ll learn

  • Load data from flat file formats
  • Explore patterns for executing SSIS packages
  • Discover a pattern for loading XML data
  • Migrate SSIS packages through your application lifecycle without editing connections
  • Take advantage of SSIS 2012 Dependency Services
  • Build an SSIS Framework to support your application needs

Who this book is for

SQL Server 2012 Integration Services Design Patterns is for the data integration developer who is ready to take their SQL Server Integration Services (SSIS) skills to a more efficient level. It’s for the developer interested in locating a previously-tested solution quickly. SQL Server 2012 Integration Services Design Patterns is a great book for ETL (extract, transform, and load) specialists and those seeking practical uses for new features in SQL Server 2012 Integration Services. It’s an excellent choice for business intelligence and data warehouse developers.

Table of Contents

  1. Metadata Collection
  2. Execution Operations
  3. Scripting
  4. SQL Server Source Patterns
  5. Data Cleansing
  6. DB2 Source
  7. Flat File Source Patterns
  8. Parallel Data Warehouse
  9. XML
  10. Expression Language Patterns
  11. Data Warehouse
  12. Logging
  13. Slowly Changing Dimensions
  14. Loading the Cloud
  15. Reporting
  16. Parent-Child Patterns
  17. BIML
  18. Configuration
  19. Deployment
  20. Estimating ETL Projects

商品描述(中文翻譯)

《SQL Server 2012 Integration Services Design Patterns》是一本針對SQL Server Integration Services (SSIS)的配方書。書中的設計模式展示了在開發數據集成解決方案時遇到的常見問題的解決方法。使用設計模式可以提高作為SSIS開發人員的效率,因為您不需要每次都從頭開始編寫代碼。在《SSIS Design Patterns》中,我們會詳細介紹其中幾個片段,提供解決方案的技術細節。

《SQL Server 2012 Integration Services Design Patterns》不僅關注要解決的問題,還深入探討了為什麼應該以特定方式解決特定問題。通過實際示例,您將更多地了解SSIS。在適當的情況下,《SQL Server 2012 Integration Services Design Patterns》提供了替代模式的示例,並討論了何時以及在哪裡應該使用它們。本書的亮點包括ETL儀表板、SSIS框架和依賴服務等部分。

本書的內容包括解決幾個常見數據集成挑戰的解決方案、演示SQL Server 2012 Integration Services的新功能以及使用實例教授SSIS的技巧。

《SQL Server 2012 Integration Services Design Patterns》適合那些希望將其SQL Server Integration Services (SSIS)技能提升到更高效水平的數據集成開發人員。對於那些希望快速找到經過測試的解決方案的開發人員來說,這是一本很好的書。《SQL Server 2012 Integration Services Design Patterns》對於ETL(提取、轉換和加載)專家以及那些尋求SQL Server 2012 Integration Services新功能實際應用的人來說是一個很好的選擇。它也非常適合商業智能和數據倉庫開發人員。

本書的目錄包括:
1. 元數據收集
2. 執行操作
3. 腳本編寫
4. SQL Server數據源模式
5. 數據清洗
6. DB2數據源
7. 平面文件數據源模式
8. 平行數據倉庫
9. XML數據源
10. 表達式語言模式
11. 數據倉庫
12. 日誌記錄
13. 緩慢變化的維度
14. 雲端數據加載
15. 報表
16. 父子模式
17. BIML
18. 配置
19. 部署
20. 估算ETL項目