Extract, Transform, & Load
SQL Server 2014
| Expert
- 12 videos | 1h 28m 13s
- Includes Assessment
- Earns a Badge
SQL Server 2014 provides an Extract, Transform, and Load (ETL) process to populate the data warehouse from the source systems. Examine ETL package design for gathering and transforming the source data.
WHAT YOU WILL LEARN
-
describe the common ETL data flow architectures used in a BI Project
describe the considerations that affect the design of data extraction from the data sources
describe how to minimize the load times and hardware resource utilization, and plan the extraction windows
identify where transformations should take place and determine which transformation should be used
design the ETL solution to support slowly changing dimensions (SCD)
design ETL solutions to support change data capture -
handle invalid rows by redirecting the rows
use the Balanced Data Distributor, BDD, transformation to optimize package execution
determine whether to use an incremental load or a full load on the data
determine if aggregation operations should be completed directly in the SSIS pipeline or in the relational database
load partitioned fact tables using best practices for an optimal load
handle errors through error handling techniques and log audit information
IN THIS COURSE
-
1. ETL Data Flow Architectures5m 45sUpon completion of this video, you will be able to describe the common data flow architectures used in a BI Project. FREE ACCESS
-
2. Examining the Source Data for the ETL Solution9m 12sAfter completing this video, you will be able to describe the considerations that affect the design of data extraction from data sources. FREE ACCESS
-
3. Reducing Load Times and Plan Extraction Windows6m 31sUpon completion of this video, you will be able to describe how to minimize load times and hardware resource utilization, and plan extraction windows. FREE ACCESS
-
4. Transformations in an ETL Solution7m 9sIn this video, you will learn how to identify where transformations should take place and determine which transformation to use. FREE ACCESS
-
5. Implementing Slowly Changing Dimensions8m 23sIn this video, find out how to design an ETL solution to support slowly changing dimensions (SCD). FREE ACCESS
-
6. Implementing Change Data Capture8m 14sLearn how to design ETL solutions to support change data capture. FREE ACCESS
-
7. Handling Invalid Rows9m 47sLearn how to handle invalid rows by redirecting them. FREE ACCESS
-
8. Using the Balanced Data Distributor Transformation5m 37sFind out how to use the Balanced Data Distributor (BDD) transformation to optimize package execution. FREE ACCESS
-
9. Planning for Incremental Loads and Full Loads4m 55sIn this video, find out how to determine whether to use an incremental load or a full load for the data. FREE ACCESS
-
10. Aggregation Performance Design4m 51sFind out how to determine if aggregation operations should be completed directly in the SSIS pipeline or in the relational database. FREE ACCESS
-
11. Loading Partitioned Fact Tables8m 50sFind out how to load partitioned fact tables using best practices for an optimal load. FREE ACCESS
-
12. Handling Errors and Audit Information9m 1sIn this video, find out how to handle errors through error handling techniques and logging audit information. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
