Muutke küpsiste eelistusi

E-raamat: Pro SQL Server 2012 Integration Services

, ,
  • Formaat: PDF+DRM
  • Ilmumisaeg: 12-Sep-2012
  • Kirjastus: APress
  • Keel: eng
  • ISBN-13: 9781430236931
Teised raamatud teemal:
  • Formaat - PDF+DRM
  • Hind: 55,56 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
Pro SQL Server 2012 Integration ServicesSuurem pilt
  • Formaat: PDF+DRM
  • Ilmumisaeg: 12-Sep-2012
  • Kirjastus: APress
  • Keel: eng
  • ISBN-13: 9781430236931
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

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. Youll 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
About the Authors xvii
About the Technical Reviewer xviii
Chapter 1 Introducing Integration Services
1(10)
A Brief History of Microsoft ETL
1(1)
What Can SSIS Do for You?
2(1)
What Is Enterprise ETL?
3(2)
SSIS Architecture
5(3)
New SSIS Features
8(1)
Our Favorite People and Places
9(1)
Summary
10(1)
Chapter 2 BIDS and SSMS
11(32)
SQL Server Business Intelligence Development Studio
11(7)
Analysis Services Project
12(2)
Integration Services Project
14(1)
Report Server Project Wizard
15(1)
Report Server Project
15(1)
Import Analysis Services Database
16(1)
Integration Services Project Wizard
16(1)
Report Model Project
16(2)
Integration Services
18(15)
Project Files
19(2)
Tool Windows
21(2)
Designer Window
23(10)
SQL Server Management Studio
33(9)
Tool Windows
33(4)
SQL Server Management Studio Project
37(1)
Templates
37(2)
Code Snippets
39(3)
Queries for SSIS
42(1)
Summary
42(1)
Chapter 3 Hello World---Your First SSIS 2012 Package
43(40)
Integration Services Project
43(4)
Key Package Properties
44(1)
Package Annotations
45(1)
Package Property Categories
46(1)
Hello World
47(23)
Flat File Source Connection
49(4)
OLE DB Destination Connection
53(4)
Data Flow Task
57(13)
Real World
70(11)
Control Flow
70(1)
Execute SQL Task
71(1)
Data Flow Task
72(9)
Summary
81(2)
Chapter 4 Connection Managers
83(24)
Commonly Used Connection Managers
83(11)
OLE DB Connection Managers
85(2)
File Connection Managers
87(3)
ADO.NET Connection Manager
90(2)
Cache Connection Manager
92(2)
Other Connection Managers
94(11)
FTP Connection Manager
94(2)
HTTP Connection Manager
96(2)
MSOLAP100 Connection Manager
98(1)
DQS Connection Manager
99(1)
MSMQ Connection Manager
99(1)
SMO Connection Manager
100(1)
SMTP Connection Manager
100(1)
SQLMOBILE Connection Manager
101(3)
WMI Connection Manager
104(1)
Summary
105(2)
Chapter 5 Control Flow Basics
107(56)
What Is a Control Flow?
107(1)
SSIS Toolbox for Control Flow
108(2)
Favorite Tasks
110(9)
Data Flow Task
110(1)
Execute SQL Task
111(8)
Common Tasks
119(36)
Analysis Services Processing Task
120(6)
Bulk Insert Task
126(4)
Data Profiling Task
130(4)
Execute Package Task
134(4)
Execute Process Task
138(2)
File System Task
140(1)
FTP Task
141(3)
Script Task
144(3)
Send Mail Task
147(2)
Web Service Task
149(3)
XML Task
152(3)
Precedence Constraints
155(2)
Basic Containers
157(2)
Containers
157(1)
Groups
158(1)
Breakpoints
159(2)
Summary
161(2)
Chapter 6 Advanced Control Flow Tasks
163(40)
Advanced Tasks
163(31)
Analysis Services Execute DDL Task
163(2)
Data Mining Query Task
165(5)
Message Queue Task
170(5)
Transfer Database Task
175(2)
Transfer Error Messages Task
177(3)
Transfer Jobs Task
180(2)
Transfer Logins Task
182(2)
Transfer Master Stored Procedures Task
184(2)
Transfer SQL Server Objects Task
186(4)
WMI Data Reader Task
190(2)
WMI Event Watcher Task
192(2)
Advanced Containers
194(8)
For Loop Container
194(2)
Foreach Loop Container
196(6)
Task Host Controller
202(1)
Summary
202(1)
Chapter 7 Source and Destination Adapters
203(42)
The Data Flow
203(2)
Sources and Destinations
205(1)
Source Assistant
205(7)
Destination Assistant
212(5)
Database Sources and Destinations
217(9)
OLE DB
218(8)
ADO.NET
226(1)
SQL Server Destination
226(1)
SQL Server Compact
226(1)
Files
226(17)
Flat Files
227(6)
Excel Files
233(9)
Raw Files
242(1)
XML Files
243(1)
Special-Purpose Adapters
243(1)
Analysis Services
244(1)
Summary
244(1)
Chapter 8 Data Flow Transformations
245(80)
High-Level Data Flow
245(1)
Types of Transformations
246(3)
Synchronous Transformations
247(1)
Asynchronous Transformations
247(1)
Blocking Transformations
248(1)
Row Transformations
249(31)
Data Conversion
249(5)
Character Map
254(3)
Copy Column
257(2)
Derived Column
259(3)
Import Column
262(3)
OLE DB Command
265(4)
Export Column
269(2)
Script Component
271(9)
Rowset Transformations
280(17)
Aggregate
281(2)
Sort
283(4)
Pivot
287(2)
Percentage Sampling
289(2)
Row Sampling
291(2)
Unpivot
293(4)
Splits and Joins
297(22)
Lookup
297(6)
Cache Transformation
303(6)
Conditional Split
309(3)
Multicast
312(1)
Union All
313(1)
Merge
314(2)
Merge Join
316(3)
Auditing
319(4)
Row Count
319(2)
Audit
321(2)
Business Intelligence Transformations
323(1)
Summary
324(1)
Chapter 9 Variables, Parameters, and Expressions
325(36)
What Are Variables and Expressions?
325(3)
What Are Parameters?
328(3)
SSIS Data Types
331(3)
Variable Scope, Default Values, and Namespaces
334(3)
Scope
334(3)
Default Values
337(1)
Namespaces
337(1)
System Variables
337(5)
Package System Variables
338(1)
Container System Variable
339(1)
Task System Variables
339(1)
Event Handler System Variables
340(2)
Accessing Variables
342(12)
Parameterized Queries
343(1)
Derived Column Transformations
344(1)
Conditional Splits
345(1)
Recordset Destinations
346(2)
Foreach Loop Containers
348(2)
Script Tasks
350(2)
Execute SQL Task Result Sets
352(1)
Source Types
353(1)
Dynamic SQL
354(2)
Passing Variables
356(1)
SSIS Expression Language
357(3)
Functions
357(2)
Operators
359(1)
Summary
360(1)
Chapter 10 Scripting
361(44)
Script Task
361(5)
Advanced Functionality
366(9)
Script Component Source
375(8)
Synchronous Script Component Transformation
383(5)
Asynchronous Script Component Transformation
388(8)
Script Component Destination
396(7)
Summary
403(2)
Chapter 11 Events and Error Handling
405(22)
SSIS Events
405(2)
Logging Events
407(11)
Script Events
418(5)
Script Task Events
418(3)
Script Component Events
421(2)
Event Handlers
423(2)
Summary
425(2)
Chapter 12 Data Profiling and Scrubbing
427(38)
Data Profiling
427(25)
Data Profiling Task
428(5)
Data Profile Viewer
433(3)
Column Length Distribution Profile
436(2)
Column Null Ratio Profile
438(2)
Column Pattern Profile
440(3)
Column Statistics Profile
443(2)
Column Value Distribution Profile
445(2)
Candidate Key Profile
447(3)
Functional Dependency Profile
450(2)
Fuzzy Searching
452(8)
Fuzzy Lookup
452(6)
Fuzzy Grouping
458(2)
Data Previews
460(4)
Data Viewer
460(2)
Data Sampling
462(2)
Summary
464(1)
Chapter 13 Logging and Auditing
465(22)
Logging
465(7)
Enabling Logging
466(4)
Choosing Log Events
470(1)
On SQL Logging
471(1)
Summary Auditing
472(9)
Batch-Level Auditing
473(5)
Package-Level Auditing
478(2)
Adding Auditing to Packages
480(1)
Simple Data Lineage
481(5)
Summary
486(1)
Chapter 14 Heterogeneous Sources and Destinations
487(24)
SQL Server Sources and Destinations
487(7)
Other RDBMS Sources and Destinations
494(1)
Flat File Sources and Destinations
495(3)
Excel Sources and Destinations
498(4)
XML Sources
502(2)
Raw File Sources and Destinations
504(2)
SQL Server Analysis Services Sources
506(2)
Recordset Destination
508(1)
Summary
509(2)
Chapter 15 Data Flow Tuning and Optimization
511(14)
Limiting Rows at the Database
511(4)
Performing Joins in the Database
515(1)
Sorting in the Database
516(1)
Performing Complex Preprocessing at the Database
516(1)
Ensuring Security and "Read Auditing"
517(1)
Pulling Too Many Columns
517(1)
Using Execution Trees
518(4)
Implementing Parallelism
522(1)
Summary
523(2)
Chapter 16 Parent-Child Design Pattern
525(18)
Understanding the Parent-Child Design Pattern
525(2)
Using Parameters to Pass Values
527(3)
Working with Shared Configuration Information
530(1)
Overriding Properties
530(1)
Logging
531(1)
Implementing Data-Driven ETL
531(11)
Summary
542(1)
Chapter 17 Dimensional Data ETL
543(18)
Introducing Dimensional Data
543(3)
Creating Quick Wins
546(4)
Run in Optimized Mode
546(1)
Remove "Dead-End" Components
547(1)
Keep Package Size Small
548(1)
Optimize Lookups
549(1)
Keep Your Data Moving
549(1)
Minimize Logging
549(1)
Use the Fast Load Option
550(1)
Understanding Slowly Changing Dimensions
550(9)
Type 0 Dimensions
550(1)
Type 1 Dimensions
550(6)
Type 2 Dimensions
556(2)
Type 3 Dimensions
558(1)
Summary
559(2)
Chapter 18 Building Robust Solutions
561(18)
What Makes a Solution Robust
561(1)
Resilience
562(11)
Data Flow Task
562(10)
Event Handlers
572(1)
Dynamism
573(1)
Accountability
574(3)
Log Providers
574(1)
Custom Logging
575(2)
Summary
577(2)
Chapter 19 Deployment Model
579(26)
The Build Process
579(2)
The Deployment Process
581(7)
Environments
588(6)
Execution
594(7)
The Import Process
601(1)
The Migration Process
601(3)
Summary
604(1)
Index 605
Francis Rodrigues is a business intelligence consultant based out of New York City. A computer science graduate of Loyola College in Maryland, he is an expert developer of enterprise business intelligence projects. His specialties include extract, transfer, load (ETL) solutions based on SQL Server, SQL Server Integration Services (SSIS), and Oracle.
Lisainfo e-raamatute kohta Lisainfo e-raamatute kohta
Püsilink: https://www.kriso.ee/db/97814302369312e.html
Märksõnad: