Extract, Transform, & Load

SQL Server 2014    |    Expert
  • 12 Videos | 1h 28m 13s
  • Includes Assessment
  • Earns a Badge
Likes 103 Likes 103
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

  • Playable
    1. 
    ETL Data Flow Architectures
    5m 45s
    UP NEXT
  • Playable
    2. 
    Examining the Source Data for the ETL Solution
    9m 12s
  • Locked
    3. 
    Reducing Load Times and Plan Extraction Windows
    6m 31s
    FREE ACCESS
  • Locked
    4. 
    Transformations in an ETL Solution
    7m 9s
    FREE ACCESS
  • Locked
    5. 
    Implementing Slowly Changing Dimensions
    8m 23s
    FREE ACCESS
  • Locked
    6. 
    Implementing Change Data Capture
    8m 14s
    FREE ACCESS
  • Locked
    7. 
    Handling Invalid Rows
    9m 47s
    FREE ACCESS
  • Locked
    8. 
    Using the Balanced Data Distributor Transformation
    5m 37s
    FREE ACCESS
  • Locked
    9. 
    Planning for Incremental Loads and Full Loads
    4m 55s
    FREE ACCESS
  • Locked
    10. 
    Aggregation Performance Design
    4m 51s
    FREE ACCESS
  • Locked
    11. 
    Loading Partitioned Fact Tables
    8m 50s
    FREE ACCESS
  • Locked
    12. 
    Handling Errors and Audit Information
    9m 1s
    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 of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

COURSE Traditional Data Architectures: Data Warehousing and ETL Systems
COURSE Data Warehousing with Azure: Implementing Azure SQL Data Warehouse
Likes 11 Likes 11  
COURSE Data Flow Implementation & ETL
Likes 37 Likes 37  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE SQL Concepts & Queries
Likes 498 Likes 498  
COURSE QlikView: Extract, Transform, & Load (ETL)
Likes 58 Likes 58  
COURSE Shell Scripting
Likes 141 Likes 141