Data Transformation & Flow

SQL Server 2014    |    Intermediate
  • 10 videos | 59m 39s
  • Includes Assessment
  • Earns a Badge
Rating 5.0 of 5 users Rating 5.0 of 5 users (5)
When working with data in a data warehouse, some level of transformation is usually required between the source and destination. Learn how to work with transformations and design data flow.

WHAT YOU WILL LEARN

  • Determine the need for supporting slowly changing dimensions transformations
    Determine whether to use sql joins or ssis lookup or merge join transformations
    Describe batch processing and row-by-row processing
    Describe identity mapping methods
    Recognize methods for deduplication
  • Describe fuzzy lookup
    Implement a fuzzy lookup in ssis
    Determine what to do with erroneous and changed rows
    Determine auditing needs for ssis packages
    Use data flow to load data in sql server 2014

IN THIS COURSE

  • 5m 19s
    In this video, you will learn how to determine the need for supporting Slowly Changing Dimensions transformations. FREE ACCESS
  • 6m
    During this video, you will learn how to determine whether to use SQL Joins, SSIS lookup, or merge join transformations. FREE ACCESS
  • Locked
    3.  Processing Options
    3m 45s
    After completing this video, you will be able to describe batch processing and row-by-row processing. FREE ACCESS
  • Locked
    4.  Identity Mapping
    6m 15s
    After completing this video, you will be able to describe identity mapping methods. FREE ACCESS
  • Locked
    5.  Deduplication
    4m 7s
    After completing this video, you will be able to recognize methods for removing duplicates. FREE ACCESS
  • Locked
    6.  Fuzzy Lookup
    6m 6s
    Upon completion of this video, you will be able to describe what fuzzy lookup is. FREE ACCESS
  • Locked
    7.  Implementing a Fuzzy Lookup
    9m 36s
    During this video, you will learn how to implement a fuzzy lookup in SSIS. FREE ACCESS
  • Locked
    8.  Erroneous Rows
    5m 8s
    In this video, find out how to determine what to do with incorrect and changed rows. FREE ACCESS
  • Locked
    9.  Auditing
    6m 44s
    Determine auditing needs for SSIS packages. FREE ACCESS
  • Locked
    10.  Exercise: Use Data Flow in SQL Server 2014
    6m 39s
    To learn how to use data flow to load data in SQL Server 2014, consult the documentation or a tutorial. 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

Journey How to Transform Tables with SQL
Book Leveling Up with SQL: Advanced Techniques for Transforming Data into Insights
Course Data Warehouse Essential: Concepts
Rating 4.4 of 292 users Rating 4.4 of 292 users (292)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Connection Managers & Data Sources
Rating 3.8 of 6 users Rating 3.8 of 6 users (6)
Course SSIS Variables
Rating 4.4 of 21 users Rating 4.4 of 21 users (21)
Course Traditional Data Architectures: Data Warehousing and ETL Systems
Rating 4.5 of 364 users Rating 4.5 of 364 users (364)