Expert SQL Server 2005 Integration Services
(Sprache: Englisch)
Developing data processing extraction, transformation, and loading (ETL) solutions is now easier than ever with this practical guide. It shows you how to apply the components of SQL Server 2005 Integration Services (SSIS) to build an enterprise ETL...
Leider schon ausverkauft
versandkostenfrei
Buch
41.56 €
Produktdetails
Produktinformationen zu „Expert SQL Server 2005 Integration Services “
Developing data processing extraction, transformation, and loading (ETL) solutions is now easier than ever with this practical guide. It shows you how to apply the components of SQL Server 2005 Integration Services (SSIS) to build an enterprise ETL application that scales and performs to your specifications. You'll not only learn how to design and implement the necessary architecture, you'll also find out how to utilize the proper administration techniques.
Written by two SQL Server MVPs, this book first provides you with all the background and foundation information you'll need on scripting and data extraction. It then takes you through the details of data warehousing ETL, error handling, administration, and data integration. By following this approach, you'll quickly discover how to take advantage of SSIS functionality to meet your data integration and processing requirements.
What you will learn from this book
* Powerful uses of scripting to develop more advanced applications
*
All about the relational database transformation and loading methods for dimension and fact tables
*
Steps for creating sophisticated solutions that easily handle processing errors
*
Best practices for moving between your support and production environments
*
Tips for leveraging SSIS features that make your migrated packages better
*
How to design and tune your packages to achieve the most scalability
Who this book is for
This book is for experienced SQL Server database developers, architects, and administrators who want to build ETL applications using SSIS.
Wrox Expert books present the wisdom accumulated by an experienced author team who is recognized as experts by the programming community. These experts challenge professional developers to examine their current practices in pursuit of better results.
Enhance Your Knowledge
Advance Your Career
Klappentext zu „Expert SQL Server 2005 Integration Services “
When it comes to developing an enterprise ETL system, moving from theory to practice often presents the biggest hurdle. Not only can the primary data processing tasks be complex in themselves, but add in administration, error handling, scalability, testing and deployment and the result is like juggling spinning plates. It's no wonder why ETL consumes over 60 percent of an enterprise data warehouse development effort.There are two keys to a successful ETL solution: using the right enterprise ETL tool and employing the right ETL architecture in order to meet the system requirements. With SQL Server 2005 Integration Services, half the battle is won. The out-of-the-box features provide the depth and breadth of functionality and flexibility needed to create scalable solutions. Even more, the usability and rapid learning curve reduce solution development time.The second ingredient is correct ETL architecture and design. When considerable effort is spent testing scenarios and proving outdesigns, valuable testing, implementation, and deployment time is lost. This book fills that gap. As a practical guide for Integration Services ETL development, you will learn 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 design with multiple examples and related Integration Services features. Putting it all together to get a solution over the goal line requires knowing the big picture and coordinating all the pieces. The book, in short: ETL soup to nuts with Integration Services.
Inhaltsverzeichnis zu „Expert SQL Server 2005 Integration Services “
Acknowledgments.Introduction.Chapter 1: Getting Started.Chapter 2: Extending Scripts in SSIS.Chapter 3: Data Extraction.Chapter 4: Dimension ETL with SSIS.Chapter 5: Fact Table ETL.Chapter 6: Processing Analysis Services Objects with SSIS.Chapter 7: Package Reliability.Chapter 8: Deployment.Chapter 9: Managing SSIS.Chapter 10: Handling Heterogeneous and Unusual Data.Chapter 11: Migrating from DTS to SSIS.Chapter 12: Scaling SSIS.Index.
Autoren-Porträt von Brian Knight, Erik Veerman
Brian Knight (MCSE, MCDBA) is a Senior Database Administrator at Alltel in Jacksonville, Florida, where he manages the mortgage enterprise database system. Brian focuses his developmental time on merging database technologies such as Oracle and DB2 into SQL Server, using DTS and OLAP. He also writes several weekly columns and co-runs the SQL Server area of Swynk.com (a BackOffice-focused Internet site) and writes columns for SQL Magazine.
Bibliographische Angaben
- Autoren: Brian Knight , Erik Veerman
- 2007, 432 Seiten, mit Schwarz-Weiß-Abbildungen, Maße: 19 x 23,4 cm, Kartoniert (TB), Englisch
- Verlag: Wiley & Sons
- ISBN-10: 0470134119
- ISBN-13: 9780470134115
Sprache:
Englisch
Kommentar zu "Expert SQL Server 2005 Integration Services"
0 Gebrauchte Artikel zu „Expert SQL Server 2005 Integration Services“
Zustand | Preis | Porto | Zahlung | Verkäufer | Rating |
---|
Schreiben Sie einen Kommentar zu "Expert SQL Server 2005 Integration Services".
Kommentar verfassen