Data Transformation & Flow

SQL Server 2014
  • 10 Videos | 1h 4m 9s
  • Includes Assessment
  • Earns a Badge
Likes 12 Likes 12
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

  • Playable
    1. 
    Slowly Changing Dimensions Transformation
    5m 19s
    UP NEXT
  • Playable
    2. 
    Implementing Transformations
    6m
  • Locked
    3. 
    Processing Options
    3m 45s
  • Locked
    4. 
    Identity Mapping
    6m 15s
  • Locked
    5. 
    Deduplication
    4m 7s
  • Locked
    6. 
    Fuzzy Lookup
    6m 6s
  • Locked
    7. 
    Implementing a Fuzzy Lookup
    9m 36s
  • Locked
    8. 
    Erroneous Rows
    5m 8s
  • Locked
    9. 
    Auditing
    6m 44s
  • Locked
    10. 
    Exercise: Use Data Flow in SQL Server 2014
    6m 39s

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

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 26 Likes 26  
Likes 15 Likes 15