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

BOOK Querying SQL Server: Run T-SQL Operations, Data Extraction, Data Manipulation, and Custom Queries to Deliver Simplified Analytics
CHANNEL Microsoft Certified: Power BI Data Analyst Associate
Likes 119 Likes 119  
COURSE Processing Data: Using Kafka with Cassandra & Confluent

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Implementing BI Infrastructure
Likes 44 Likes 44  
COURSE Traditional Data Architectures: Data Warehousing and ETL Systems
COURSE Data Warehouse Essential: Concepts
Likes 144 Likes 144