Extract, Transform, & Load

SQL Server 2014
  • 12 Videos | 1h 28m 49s
  • Includes Assessment
  • Earns a Badge
Likes 57 Likes 57
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 47s
    UP NEXT
  • Playable
    2. 
    Examining the Source Data for the ETL Solution
    9m 15s
  • Locked
    3. 
    Reducing Load Times and Plan Extraction Windows
    6m 34s
    FREE ACCESS
  • Locked
    4. 
    Transformations in an ETL Solution
    7m 12s
    FREE ACCESS
  • Locked
    5. 
    Implementing Slowly Changing Dimensions
    8m 26s
    FREE ACCESS
  • Locked
    6. 
    Implementing Change Data Capture
    8m 17s
    FREE ACCESS
  • Locked
    7. 
    Handling Invalid Rows
    9m 50s
    FREE ACCESS
  • Locked
    8. 
    Using the Balanced Data Distributor Transformation
    5m 40s
    FREE ACCESS
  • Locked
    9. 
    Planning for Incremental Loads and Full Loads
    4m 58s
    FREE ACCESS
  • Locked
    10. 
    Aggregation Performance Design
    4m 54s
    FREE ACCESS
  • Locked
    11. 
    Loading Partitioned Fact Tables
    8m 53s
    FREE ACCESS
  • Locked
    12. 
    Handling Errors and Audit Information
    9m 4s
    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 SQL Transactions
Likes 39 Likes 39  
COURSE Implementing Control Flow
Likes 8 Likes 8  
COURSE Designing & Implementing Dimensions
Likes 15 Likes 15  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Data Flow Implementation & ETL
Likes 26 Likes 26  
COURSE Implementing BI Infrastructure
Likes 25 Likes 25  
COURSE BI Project Deployment
Likes 12 Likes 12