How to Use Select Transformation and New Branch in Mapping Data Flow in Azure Data Factory - 2022

Описание: How to Use Select Transformation and New Branch in Mapping Data Flow in Azure Data Factory - 2022, in this video we are going to learn How to Use Select Transformation and New Branch in Mapping Data Flow in Azure Data Factory - 2022, Azure Data Factory Step by Step - ADF Tutorial 2022 - ADF Tutorial 2022 Step by Step ADF Tutorial - Azure Data Factory Tutorial 2022
Script:
How to use Select Transformation and New Branch in Mapping Data Flow in Azure Data Factory - Data Factory Tutorial 2022
Table Definition used in Demo

create table dbo.Product(id int identity(1,1),
ProductName varchar(100))

create table dbo.SalePerson(SalePersonId int,
SalePersonFName varchar(100), SalePersonLName varchar(100))

create table dbo.Region(RegionId int identity(1,1),City varchar(100),
State varchar(100),Country varchar(100),Region
varchar(100))

Select * From dbo.Product
Select * from dbo.Region
Select * From dbo.SalePerson


TotalSale.csv File used in demo
id,SalePersonFName,SalePersonLName,ProductName,ItemsSold,SoldPrice,SoldDate,City,State,Country,Region
1,Aleena,Aman,Laptop,2,800,5/25/2015,Lahore,Punjab,Pakistan,Asia
2,Najaf,Ali,Computer,1,300,6/20/2015,Karachi,Sindh,Pakistan,Asia
3,Sukhjeet,Singh,TV,2,900,6/21/2015,ChandiGar,Punjab,India,Asia
4,Chirag,Patel,Cell Phone,5,1500,6/23/2015,AhmadAbad,Gujrat,India,Asia
5,Aamir,Shahzad,TV,1,700,7/15/2015,Charlotte,NC,USA,North America
6,M,Raza,Cell Phone,2,800,7/15/2015,Charlotte,NC,USA,North America
7,Tamara,Tony,Cell Phone,2,1200,3/3/2015,Frankfurt,Hesse,Germany,Europe
8,Rita,Roger,Laptop,7,2100,4/11/2015,Paris,Île-de-France,France,Europe
9,Petra,Henry,TV,10,5000,4/8/2015,Paris,Île-de-France,France,Europe
10,Christy,Ladson,TV,3,1600,4/2/2015,High Point,NC,USA,North America
11,John,Rivers,Laptop,5,2400,3/9/2014,Jersey City,NJ,USA,North America
12,John,Rivers,Laptop,5,2400,3/9/2014,Jersey City,NJ,USA,Africa

Azure Data Factory Tutorial for beginners
Azure Data Factory Tutorial 2022
Step by step Azure Data Factory Tutorial
Real-time Azure Data Factory Tutorial
Scenario-based training on Azure Data Factory
Best ADF Tutorial on youtube


#AzureDataFactory #ADFTutorial2022