Expert SQL server 2005 integration services
As a practical guide for Integration Services ETL development, this book shows you ways to implement your ETL solution requirements from the data to the administration and everything in-between. Each chapter begins with a review of pertinent ETL concepts and moves into working those out into a desig...
| Autor principal: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Indianapolis, IN :
Wiley Pub
c2007.
|
| Edición: | 1st edition |
| Colección: | Wrox expert one-on-one.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627006506719 |
Tabla de Contenidos:
- Expert SQL Server 2005 Integration Services; About the Authors; Contributing Author; Credits; Acknowledgments; Contents; Introduction; Whom This Book Is For; What This Book Covers; How This Book Is Structured; What You Need to Use This Book; Conventions; Source Code; Errata; p2p.wrox.com; Chapter 1: Getting Started; Choosing the Right Tool for the Job; SSIS Review; Summary; Chapter 2: Extending Scripts in SSIS; Script Tasks and Custom Libraries; Building a Custom Assembly; Making Connections Configurable and Dynamic; Raising Error Events; Encrypting Data Through Script Components
- Data ProfilingSummary; Chapter 3: Data Extraction; Package Connections and Data Flow Sources; Incremental Data Extraction; Tracking Data Lineage Identifiers; Summary; Chapter 4: Dimension ETL with SSIS; Dimension ETL Overview; Dimensions: The Basics; Dimension ETL: The Challenge; SSIS Slowly Changing Dimension Wizard; Creating a Custom Slowly Changing Package; Summary; Chapter 5: Fact Table ETL; Fact Table Overview; Fact Table ETL; Fact Table ETL Challenge; Fact Table ETL Basics; Advanced Fact Table ETL Concepts; Summary; Chapter 6: Processing Analysis Services Objects with SSIS
- SSAS ETL Processing and Management OverviewSSAS Integration Basics Within SSIS; Advanced Processing and Par tition Management Examples; Summary; Chapter 7: Package Reliability; Error and Event Handling; Logging; Checkpoint Files; Transactions; Raw Files; Proactive WMI Integration; Building a File Watcher Task; Summary; Chapter 8: Deployment; Working with a Team in SSIS; Reusable Packages; Creating a Package Template; Package Configuration; Deployment Utility; Summary; Chapter 9: Managing SSIS; The Package Store; Management Studio; Running Packages with DTExecUI; Security; Firewall Issues
- Command Line UtilitiesScheduling a Package; Proxy Accounts; 64-Bit Issues; Performance Counters; Summary; Chapter 10: Handling Heterogeneous and Unusual Data; Unusual Data Flow Scenarios; Oracle; Other Data Sources; Summary; Chapter 11: Migrating from DTS to SSIS; SQL Server 2005 DTS Backward Compatibility; Administering and Editing a DTS Package; Upgrading from DTS; Handling Exceptions; Summary; Chapter 12: Scaling SSIS; SSIS Scalability Foundations; Data Flow Optimization; Package Execution Principles; Summary; Index
