Extract, Transform, & Load

SQL Server 2014    |    Expert
  • 12 videos | 1h 28m 13s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 71 users Rating 4.5 of 71 users (71)
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

  • 5m 45s
    Upon completion of this video, you will be able to describe the common data flow architectures used in a BI Project. FREE ACCESS
  • 9m 12s
    After completing this video, you will be able to describe the considerations that affect the design of data extraction from data sources. FREE ACCESS
  • Locked
    3.  Reducing Load Times and Plan Extraction Windows
    6m 31s
    Upon 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
  • Locked
    4.  Transformations in an ETL Solution
    7m 9s
    In this video, you will learn how to identify where transformations should take place and determine which transformation to use. FREE ACCESS
  • Locked
    5.  Implementing Slowly Changing Dimensions
    8m 23s
    In this video, find out how to design an ETL solution to support slowly changing dimensions (SCD). FREE ACCESS
  • Locked
    6.  Implementing Change Data Capture
    8m 14s
    Learn how to design ETL solutions to support change data capture. FREE ACCESS
  • Locked
    7.  Handling Invalid Rows
    9m 47s
    Learn how to handle invalid rows by redirecting them. FREE ACCESS
  • Locked
    8.  Using the Balanced Data Distributor Transformation
    5m 37s
    Find out how to use the Balanced Data Distributor (BDD) transformation to optimize package execution. FREE ACCESS
  • Locked
    9.  Planning for Incremental Loads and Full Loads
    4m 55s
    In this video, find out how to determine whether to use an incremental load or a full load for the data. FREE ACCESS
  • Locked
    10.  Aggregation Performance Design
    4m 51s
    Find out how to determine if aggregation operations should be completed directly in the SSIS pipeline or in the relational database. FREE ACCESS
  • Locked
    11.  Loading Partitioned Fact Tables
    8m 50s
    Find out how to load partitioned fact tables using best practices for an optimal load. FREE ACCESS
  • Locked
    12.  Handling Errors and Audit Information
    9m 1s
    In 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.

YOU MIGHT ALSO LIKE

Course Querying SQL Databases: Learning SQL Using Prompt Engineering
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Course CompTIA Data+: Data Acquisition & Cleansing
Rating 4.6 of 13 users Rating 4.6 of 13 users (13)
Book Querying SQL Server: Run T-SQL Operations, Data Extraction, Data Manipulation, and Custom Queries to Deliver Simplified Analytics

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Traditional Data Architectures: Data Warehousing and ETL Systems
Rating 4.5 of 364 users Rating 4.5 of 364 users (364)
Course BI Reporting & Analysis
Rating 4.5 of 37 users Rating 4.5 of 37 users (37)
Course Data Flow Implementation & ETL
Rating 4.5 of 57 users Rating 4.5 of 57 users (57)