Blog Post

Azure Data Factory Blog
6 MIN READ

Create Generic SCD Pattern in ADF Mapping Data Flows

Mark Kromer's avatar
Mark Kromer
Icon for Microsoft rankMicrosoft
Oct 18, 2019
Azure Data Factory's Mapping Data Flows feature enables graphical ETL designs that are generic and parameterized. In this example, I'll show you how to create a reusable SCD Type 1 pattern that could...
Updated Oct 18, 2019
Version 2.0
Azure Data Factory
Azure ETL
Mapping Data Flows
Mark Kromer's avatar
Mark Kromer
Icon for Microsoft rankMicrosoft
Oct 25, 2019

AleLem Are you using an AlterRow transformation and a database sink? On the Sink, you must allow updates on the sink settings and you must define an update policy on the AlterRow.