2013
Pluralsight
Stacia Misner
3h 39m
English
This course teaches how to work with Integration Services packages in the context of a data warehouse development project to perform extract, transform and load operations.
This course explains how to apply Integration Services features to build packages that support the extract, transform and load operations of a data warehouse.
It covers design patterns for staging data and for loading data into fact and dimension tables.
In addtion, this course describes how to enhance ETL packages with data cleansing techniques and offers insight into the buffer architecture of the data flow engine to hep package developers get the best performance from packages.
This course was written for SQL Server 2012 Integration Services, but most principles apply to SQL Server 2005 and later.
FileName Size Length Bit rate Data rate Resolution Frame Rate Parent Folder
01.Introduction 1.76 MB 0:01:16 128kbps 87.00 1024x768 15 frames/second 01.Data Warehousing Packages, Part I
02.Introduction to Data Warehousing 6.82 MB 0:04:31 128kbps 118.00 1024x768 15 frames/second 01.Data Warehousing Packages, Part I
03.Dimensional Modeling 9.47 MB 0:05:40 128kbps 231.00 1024x768 15 frames/second 01.Data Warehousing Packages, Part I
04.Data Profiling 3.33 MB 0:02:04 128kbps 321.00 1024x768 15 frames/second 01.Data Warehousing Packages, Part I
05.Demo - Data Profiling 15.6 MB 0:08:21 128kbps 306.00 1024x768 15 frames/second 01.Data Warehousing Packages, Part I
06.ETL Design Patterns 4.29 MB 0:02:58 128kbps 89.00 1024x768 15 frames/second 01.Data Warehousing Packages, Part I
07.Extract Package 5.48 MB 0:03:56128kbps 60.00 1024x768 15 frames/second 01.Data Warehousing Packages, Part I
08.Demo - Extracting to Staging Tables 23.7 MB 0:12:04 128kbps 503.00 1024x768 15 frames/second 01.Data Warehousing Packages, Part I
09.Load Patterns 2.80 MB 0:01:50 128kbps 123.00 1024x768 15 frames/second 01.Data Warehousing Packages, Part I
10.Fact Extract for Ongoing Load 4.90 MB 0:03:15 128kbps 118.00 1024x768 15 frames/second 01.Data Warehousing Packages, Part I
11.Demo -Extracting Records since Last Load 19.0 MB 0:07:58 128kbps 783.00 1024x768 15 frames/second 01.Data Warehousing Packages, Part I
12.Summary 5.43 MB 0:03:46 128kbps 84.00 1024x768 15 frames/second 01.Data Warehousing Packages, Part I
01.Introduction 1.14 MB 0:00:50 128kbps 88.00 1024x768 15 frames/second 02.Data Warehousing Packages, Part II
02.Slowly Changing Dimensions 4.15 MB 0:02:52 128kbps 89.00 1024x768 15 frames/second 02.Data Warehousing Packages, Part II
03.Dimension Load Patterns - Type 0, Type 1, and Type 2 6.93 MB 0:04:42 128kbps 200.00 1024x768 15 frames/second 02.Data Warehousing Packages, Part II
04.Dimension Load Package 1.32 MB 0:00:54 128kbps 52.00 1024x768 15 frames/second 02.Data Warehousing Packages, Part II
05.Demo - Transforming and Loading Data for Type 0 17.8 MB 0:07:24 128kbps 1119.00 1024x768 15 frames/second 02.Data Warehousing Packages, Part II
06.Demo - Loading Data with The Slowly Changing Dimension Wizard 29.6 MB 0:13:34 128kbps 1134.00 1024x768 15 frames/second 02.Data Warehousing Packages, Part II
07.Fact Table Design Patterns 2.53 MB 0:01:39 128kbps 173.00 1024x768 15 frames/second 02.Data Warehousing Packages, Part II
08.Demo - Performing ETL for A Fact Table 19.2 MB 0:06:33 128kbps 1364.00 1024x768 15 frames/second 02.Data Warehousing Packages, Part II
09.Demo - Selecting Data for Ongoing Fact Table Load 4.12 MB 0:01:41 128kbps 343.00 1024x768 15 frames/second 02.Data Warehousing Packages, Part II
10.Analysis Services Objects 1.31 MB 0:00:52 128kbps 83.00 1024x768 15 frames/second 02.Data Warehousing Packages, Part II
11.Demo - Using The Analysis Services Task 9.27 MB 0:04:22 128kbps 613.00 1024x768 15 frames/second 02.Data Warehousing Packages, Part II
12.Demo - Orchestrating The ETL Process 5.61 MB 0:02:38 128kbps 902.00 1024x768 15 frames/second 02.Data Warehousing Packages, Part II
13.Summary 2.30 MB 0:01:30 128kbps 234.00 1024x768 15 frames/second 02.Data Warehousing Packages, Part II
01.Introduction 1.06 MB 0:00:45 128kbps 75.00 1024x768 15 frames/second 03.Data Cleansing
03.Column Problems - Missing Data Default 1.25 MB 0:00:48 128kbps 76.00 1024x768 15 frames/second 03.Data Cleansing
04.Demo - Derived Column 13.1 MB 0:04:27 128kbps 844.00 1024x768 15 frames/second 03.Data Cleansing
05.Columnn Problems - Derive Missing Data 1.60 MB 0:01:00 128kbps 154.00 1024x768 15 frames/second 03.Data Cleansing
06.Demo - Lookup Transformation 15.0 MB 0:05:57 128kbps 1170.00 1024x768 15 frames/second 03.Data Cleansing
07.Column Problems -Translation 2.86 MB 0:01:53 128kbps 115.00 1024x768 15 frames/second 03.Data Cleansing
08.Demo - Lookup Transformation and Cache Transformation 14.7 MB 0:06:28 128kbps 568.00 1024x768 15 frames/second 03.Data Cleansing
09.Column Problems - Data Type 2.36 MB 0:01:31 128kbps 139.00 1024x768 15 frames/second 03.Data Cleansing
10.Demo - Data Conversion Transformation 15.4 MB 0:05:08 128kbps 1322.00 1024x768 15 frames/second 03.Data Cleansing
11.Column Problems - Truncation 3.24 MB 0:02:04 128kbps 136.00 1024x768 15 frames/second 03.Data Cleansing
12.Demo - Flagging Unfixable Data Flow Errors 8.02 MB 0:03:03 128kbps 1492.00 1024x768 15 frames/second 03.Data Cleansing
13.Record Problems - Missing Dimension Data 4.70 MB 0:03:03 128kbps 144.00 1024x768 15 frames/second 03.Data Cleansing
14.Demo - Inferred Members 31.0 MB 0:11:24 128kbps 1263.00 1024x768 15 frames/second 03.Data Cleansing
15.Record Problems - Lookup Failures 2.81 MB 0:01:41 128kbps 193.00 1024x768 15 frames/second 03.Data Cleansing
16.Demo - Fuzzy Lookup Transformation 14.3 MB 0:06:45 128kbps 576.00 1024x768 15 frames/second 03.Data Cleansing
17.Record Problems - Duplicate Data 2.34 MB 0:01:22 128kbps 178.00 1024x768 15 frames/second 03.Data Cleansing
18.Record Problems - Fuzzy Grouping and Data 8.09 MB 0:03:55 128kbps 397.00 1024x768 15 frames/second 03.Data Cleansing
19.Business Rule Problems - Out of Range Values 1.64 MB 0:01:01 128kbps 173.00 1024x768 15 frames/second 03.Data Cleansing
20.Data Quality Services 3.70 MB 0:02:32 128kbps 144.00 1024x768 15 frames/second 03.Data Cleansing
21.Summary 6.07 MB 0:04:00 128kbps 350.00 1024x768 15 frames/second 03.Data Cleansing
01.Introduction 2.00 MB 0:01:27 128kbps 77.00 1024x768 15 frames/second 04.Package Performance
02.Pipeline Buffer Architecture 6.67 MB 0:04:19 128kbps 198.00 1024x768 15 frames/second 04.Package Performance
03.Non-Blocking Streaming Transformations 2.41 MB 0:01:38128kbps 122.00 1024x768 15 frames/second 04.Package Performance
04.Demo - Executing Non-Blocking Streaming Transformations 3.40 MB 0:01:35 128kbps 256.00 1024x76815 frames/second 04.Package Performance
05.Non-Blocking Row-Based Transformations 1.91 MB 0:01:17 128kbps 126.00 1024x768 15 frames/second 04.Package Performance
06.Demo - Executing Non-Blocking Row-Based Transformations 3.41 MB 0:02:01 28kbps 213.00 1024x768 15 frames/second 04.Package Performance
07.Partially Blocking Transformations 1.60 MB 0:01:05 128kbps 106.00 1024x76k 15 frames/second 04.Package Performance
08.Demo - Executing Partially BlockingTransformations 2.49 MB 0:01:20 128kbps 246.00 1024x768 15 frames/second 04.Package Performance
09.Blocking Transformations 1.35 MB 0:00:51 128kbps 90.00 1024x768 15 frames/second 04.Package Performance
10.Demo - Executing Blocking Transformations 1.55 MB 0:00:48 128kbps 216.00 1024x768 15 frames/second 04.Package Performance
11.Synchronous versus Asynchronous 1.73 MB 0:01:09 128kbps 104.00 1024x768 15 frames/second 04.Package Performance
12.Execution Trees 4.13 MB 0:02:51 128kbps 115.00 1024x768 15 frames/second 04.Package Performance
13.Demo - Reviewing The Pipeline Execution Tree Log 7.82 MB 0:04:01 128kbps 375.00 1024x768 15 frames/second 04.Package Performance
14.Performance Optimization - Buffers 5.05 MB 0:03:11 128kbps 252.00 1024x768 15 frames/second 04.Package Performance
15.Demo - Performance Optimization - Buffer Sizing 4.10 MB 0:01:57 128kbps 442.00 1024x768 15 frames/second 04.Package Performance
16.Parallelism, Transformations, Sources, and Destinations 5.17 MB 0;03:00 128kbps 229.00 1024x768 15 frames/second 04.Package Performance
17.Performance Monitoring 5.16 MB 0:03:07 128kbps 382.00 1024x768 15 frames/second 04.Package Performance
18.Summary 4.42 MB 0:02:59 128kbps 264.00 1024x768 15 frames/second 04.Package Performance
http://pluralsight.com/training/Courses/TableOfContents/ssis-advanced

Download File Size:361.22 MB

---