Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Pro SQL Server 2012 Integration Services (Professional Apress)


Pro SQL Server 2012 Integration Services teaches how to take advantage of the powerful extract, transform, and load (ETL) platform included with Microsoft SQL Server 2012. You’ll learn to build scalable, robust, performance-driven enterprise ETL solutions that save time and make money for your company. You'll learn to avoid common ETL development pitfalls and how to extend the power of your ETL solutions to include virtually any possible transformation on data from any conceivable source. SQL Server Integration Services (SSIS) facilitates an unprecedented ability to load data from anywhere, perform any type of manipulation on it, and store it to any source. 

Whether you are populating databases, retrieving data from the Web, or performing complex calculations on large data sets, SSIS gives you the tools to get the job done.  And this book gives you the knowledge to take advantage of everything SSIS offers.

  • Helps you design and develop robust, efficient, scalable ETL solutions
  • Walks you through using the built-in, stock components
  • Shows how to programmatically extend the power of SSIS to cover any possible scenario

What you’ll learn

  • Create an SSIS package from scratch
  • Deploy an SSIS package to any environment
  • Benchmark the performance of SSIS packages using common tools
  • Optimize SSIS data flows to achieve maximum performance
  • Use .NET to extend the power of the stock SSIS toolkit
  • Profile and scrub data during the ETL process

Who this book is for

Pro SQL Server 2012 Integration Services is for ETL developers, SQL developers, and database administrators at all levels of experience who want to harness the power of SSIS on SQL Server 2012. Whether you are using SSIS to build small, one-off ETL packages in a small shop, or building enterprise-wide ETL solutions in a Fortune 500 company, this book gives you the information you'll need to build powerful, scalable, and efficient ETL solutions at any level of complexity.

Table of Contents

  1. Introducing Integration Services 
  2. BIDS and SSMS 
  3. “Hello World!”—Your First SSIS 2012 Package 
  4. Connection Managers 
  5. Control Flow Basics 
  6. Advanced Control Flow Tasks 
  7. Source and Destination Adapters 
  8. Data Flow Transformations 
  9. Variables, Parameters, and Expressions 
  10. Scripting 
  11. Events and Error Handling 
  12. Data Profiling and Scrubbing 
  13. Logging, Auditing and Data Lineage
  14. Heterogeneous Sources and Destinations 
  15. Data Flow Tuning and Optimization 
  16. Parent-Child Design Pattern 
  17. Dimensional Data ETL 
  18. Building Robust Solutions 
  19. Deployment Model
(HTML tags aren't allowed.)

Special Edition Using Oracle 11i
Special Edition Using Oracle 11i
The first part of Special Edition Using Oracle 11i introduces the Oracle ERP applications and R11i concepts. The reader is then educated on proven techniques for implementing these complex and integrated systems. Configuration and usage of each of the financial, distribution, manufacturing, HRMS, and projects...
C#.net Web Developer's Guide
C#.net Web Developer's Guide
This volume teaches Web developers to build solutions for the Microsoft .NET platform. Web developers will learn to use C# components to build services and applications available across the Internet.

The focus of The C#.NET Web Developer’s Guide is on providing you with code examples that will help you leverage the
Crash Course (US): Metabolism and Nutrition: With STUDENT CONSULT Online Access
Crash Course (US): Metabolism and Nutrition: With STUDENT CONSULT Online Access
Don't panic! "Crash Course" is herethat perfect set of lecture notes which no student ever really has the time to compile. These books deliver all of the information needed to get through a course or prepare for exams. Clear text covers the essential concepts of each discipline or specialty; learning features expedite mastery of the...

The Oxford Handbook of Political Economy (Oxford Handbooks of Political Science)
The Oxford Handbook of Political Economy (Oxford Handbooks of Political Science)
Over its long lifetime, the phrase “political economy” has had many different meanings. For Adam Smith, political economy was the science of managing a nation’s resources so as to generate wealth. For Marx, it was how the ownership of the means of production influenced historical processes. For much of the twentieth century, the...
Data Dissemination in Wireless Computing Environments (Advances in Database Systems)
Data Dissemination in Wireless Computing Environments (Advances in Database Systems)
In our increasingly mobile world the ability to access information on demand at any time and place can satisfy people's information needs as well as confer on them a competitive advantage. The emergence of battery-operated, low-cost and portable computers such as palmtops and PDAs, coupled with the availability and exploitation of wireless...
Asterisk Cookbook
Asterisk Cookbook

Asterisk has a wealth of features to help you customize your PBX to fill very specific business needs. This short cookbook offers recipes for tackling dialplan fundamentals, making and controlling calls, and monitoring channels in your PBX environment. Each recipe includes a simple code solution you can put to work immediately, along...

©2020 LearnIT (support@pdfchm.net) - Privacy Policy