Articoli correlati a Hands-On Microsoft SQL Server™ 2005 Integration...

Hands-On Microsoft SQL Server™ 2005 Integration Services - Brossura

Nanda, Ashwani

 
9780072263190: Hands-On Microsoft SQL Server™ 2005 Integration Services

Sinossi

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.


In-depth coverage of Microsoft’s powerfulnew data integration tool

Learn to maximize the features ofSQL Server 2005 Integration Services from this essentialguide. Hands-On Microsoft SQL Server 2005 IntegrationServices makes learning SSIS easy through theuse of extensive real-world exercises structuredaround every component within the tool. You willlearn to collect corporate data from various sourcesand transform that data for analysis, mining, andreporting.

Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.

Informazioni sull'autore

McGraw-Hill authors represent the leading experts in their fields and are dedicated to improving the lives, careers, and interests of readers worldwide

Dalla quarta di copertina

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.


Build robust, high-performance Business Intelligence solutions with SSIS

Extract, transform, and consolidate data from disparate sources and move it to single or multiple destinations using SQL Server 2005 Integration Services -- the next-generation data integration platform. Hands-On Microsoft SQL Server 2005 Integration Services shows you, step-by-step, how to build and manage SSIS packages, draw out meaningful information from raw data, and deliver de-duplicated and cleansed data to business applications and corporate reports. Inside, you'll get detailed information on migrating to SQL Server 2005 Integration Services, enhancing performance, and implementing encryption policies to secure SSIS packages.

ESSENTIAL SKILLS FOR DATABASE PROFESSIONALS:

  • Build packages with the SSIS Import and Export Wizard and BIDS
  • Create expressions using variables, functions, and operators
  • Lay out package workflow with Control Flow Containers and tasks
  • Secure SSIS packages and encrypt sensitive data
  • Monitor and audit runtime events using log providers
  • Respond to external triggers with event handlers
  • Transform and manipulate input using Data Flow Components
  • Standardize, de-duplicate, and cleanse data with Fuzzy Lookup and Fuzzy Grouping transformations
  • Load Data warehouse using Slowly Changing Dimension transformation
  • Deploy, optimize, troubleshoot, and debug SSIS packages

Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.