Azure Data Factory - How to Use Sequence numbers and Identity Columns - Delta Dimension tables

preview_player
Показать описание
In this video, we go through a very simple example of how to generate and use sequence numbers in Azure Data Factory. It is a common scenario to create dimension tables in a star schema and ,therefore, necessary to generate Sequence numbers for Identity columns. We are able to achieve this by utilizing Data Flows.

Follow me on social media:

00:00 - Intro
01:18 - Create Surrogate Key
09:50 - Aggregate, Join and Derived Column
10:45 - Alter Row & Upsert
12:34 - Conclusion
Рекомендации по теме
Комментарии
Автор

This is very helpful. Thanks for the detailed walk through!

JeremyZhou-vh