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 Projectdescribe the considerations that affect the design of data extraction from the data sourcesdescribe how to minimize the load times and hardware resource utilization, and plan the extraction windowsidentify where transformations should take place and determine which transformation should be useddesign the ETL solution to support slowly changing dimensions (SCD)design ETL solutions to support change data capture
-
handle invalid rows by redirecting the rowsuse the Balanced Data Distributor, BDD, transformation to optimize package executiondetermine whether to use an incremental load or a full load on the datadetermine if aggregation operations should be completed directly in the SSIS pipeline or in the relational databaseload partitioned fact tables using best practices for an optimal loadhandle errors through error handling techniques and log audit information
IN THIS COURSE
-
1.ETL Data Flow Architectures5m 45sUP NEXT
-
2.Examining the Source Data for the ETL Solution9m 12s
-
3.Reducing Load Times and Plan Extraction Windows6m 31s
-
4.Transformations in an ETL Solution7m 9s
-
5.Implementing Slowly Changing Dimensions8m 23s
-
6.Implementing Change Data Capture8m 14s
-
7.Handling Invalid Rows9m 47s
-
8.Using the Balanced Data Distributor Transformation5m 37s
-
9.Planning for Incremental Loads and Full Loads4m 55s
-
10.Aggregation Performance Design4m 51s
-
11.Loading Partitioned Fact Tables8m 50s
-
12.Handling Errors and Audit Information9m 1s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.