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...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Knight, Brian, 1976-
Otros Autores: Veerman, Erik, 1973-
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Indianapolis, IN : Wiley Pub., ©2007.
Colección:Wrox expert one-on-one.
Temas:
SQL server.
Database management.
Data warehousing.
Bases de données > Gestion.
Entrepôts de données (Informatique)
COMPUTERS > Data Processing.
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Cover
  • 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 Profiling
  • Summary
  • 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 Overview
  • SSAS 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 Utilities
  • Scheduling 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
  • Last Page.

Ejemplares similares