1. Home
  2. Training Library
  3. Microsoft Azure
  4. Courses
  5. Handling Slowly Changing Dimensions With Azure Synapse Analytics Pipelines

Handling Slowly Changing Dimensions With Azure Synapse Analytics Pipelines

Contents

keyboard_tab
Handling Slowly Changing Dimensions With Azure Synapse Analytics Pipelines
1
Introduction
PREVIEW1m 1s
6
Summary
2m 49s

The course is part of this learning path

DP-203 Exam Preparation: Data Engineering on Microsoft Azure
13
1
7
1
Introduction
Overview
Difficulty
Advanced
Duration
30m
Students
214
Ratings
4.8/5
starstarstarstarstar-half
Description

In this course, we’ll explain the concept of slowly changing dimensions and the different approaches to dealing with them. Then we’ll show you how to create a data flow in Azure Synapse Pipelines to update slowly changing dimensions. Even if you’re not particularly interested in how to handle slowly changing dimensions, the demos in this course will give you a good idea of how to create data flows in either Azure Synapse Pipelines or Azure Data Factory since they both use the same interface.

Learning Objectives

  • Understand various methods for handling slowly changing dimensions in databases
  • Create a data flow in Azure Synapse Pipelines that updates slowly changing dimensions in a database table

Intended Audience

  • Anyone who would like to learn about slowly changing dimensions in databases
  • Anyone who needs to know how to create data flows in Azure Synapse Analytics Pipelines and Azure Data Factory

Prerequisites

  • Some knowledge of Azure Synapse Analytics, specifically dedicated SQL pools and Synapse Pipelines (take Introduction to Azure Synapse Analytics if you’re not familiar with this Microsoft service)
  • Experience with SQL (not mandatory)



Transcript

Welcome to “Handling Slowly Changing Dimensions With Azure Synapse Analytics Pipelines”. Whew, I think that’s the longest course title I’ve ever had. I’m Guy Hummel, and I’m a certified Azure Data Engineer.

In this course, I’ll explain the concept of slowly changing dimensions and the different approaches to dealing with them. Then I’ll show you how to create a data flow in Azure Synapse Pipelines to update slowly changing dimensions. Even if you’re not particularly interested in how to handle slowly changing dimensions, the demos in this course will give you a good idea of how to create data flows in either Azure Synapse Pipelines or Azure Data Factory since they both use the same interface.

To get the most from this course, you should already have some knowledge of Azure Synapse Analytics, specifically dedicated SQL pools and Synapse Pipelines. If you haven’t taken our Introduction to Azure Synapse Analytics course already, then please go through it before taking this course. It would also be helpful to have some experience with SQL, although that’s not mandatory.

We’d love to get your feedback on this course, so please give it a rating when you’re finished. Thanks!

About the Author
Avatar
Guy Hummel
Azure and Google Cloud Content Lead
Students
107448
Courses
66
Learning Paths
86

Guy launched his first training website in 1995 and he's been helping people learn IT technologies ever since. He has been a sysadmin, instructor, sales engineer, IT manager, and entrepreneur. In his most recent venture, he founded and led a cloud-based training infrastructure company that provided virtual labs for some of the largest software vendors in the world. Guy’s passion is making complex technology easy to understand. His activities outside of work have included riding an elephant and skydiving (although not at the same time).