Alter Row Transformation in Mapping Data Flow -Part 1 | Azure Data Factory Tutorial | Beginner Level

This is part-1 having two Alter row conditions "Insert If" and "Delete if". In Part -2 , I will cover "Update If" and "Upsert If" Use the Alter Row transformation to set insert, delete, update, and upsert policies on rows. You can add one-to-many conditions as expressions. These conditions should be specified in order of priority, as each row will be marked with the policy corresponding to the first-matching expression. Each of those conditions can result in a row (or rows) being inserted, updated, deleted, or upserted. Alter Row can produce both DDL & DML actions against your database. Alter Row transformations will only operate on database, REST, or CosmosDB sinks in your data flow. The actions that you assign to rows (insert, update, delete, upsert) won't occur during debug sessions. Run an Execute Data Flow activity in a pipeline to enact the alter row policies on your database tables Link for Microsoft official documentation is here: https://docs.microsoft.com/en-us/azure/data-factory/data-flow-alter-row #AlterRow #adfvideos #cloudknowledge #Flowlet #Flowlets #azure #adf #azuredatafactory #flowlettransformation #azureflowlet #mapplets #azuretutorials #beginnertutorial #datafactory #cloudgyaan