How to Pass Parameter and Variable Value from Pipeline to Mapping Data Flow in Azure Data Factory
How to Pass Parameter and Variable Value from Pipeline to Mapping Data Flow in Azure Data Factory | ADF Tutorial 2022, in this video we are going to learn How to Pass Parameter and Variable Value from Pipeline to Mapping Data Flow in Azure Data Factory | ADF Tutorial 2022, Azure Data Factory Step by Step - ADF Tutorial 2022 - ADF Tutorial 2022 Step by Step ADF Tutorial - Azure Data Factory Tutorial 2022
Script:
TotalSale.csv
id,SalePersonFName,SalePersonLName,ProductName,ItemsSold,SoldPrice,SoldDate,City,State,Country,Region
8,Aleena,Aman,Laptop,2,800,5/25/2015,Lahore,Punjab,Pakistan,Asia
5,Najaf,Ali,Computer,1,300,6/20/2015,Karachi,Sindh,Pakistan,Asia
6,Sukhjeet,Singh,TV,2,900,6/21/2015,ChandiGar,Punjab,India,Asia
7,Chirag,Patel,Cell Phone,5,1500,6/23/2015,AhmadAbad,Gujrat,India,Asia
1,Aamir,Shahzad,TV,1,700,7/15/2015,Charlotte,NC,USA,North America
2,M,Raza,Cell Phone,2,800,7/15/2015,Charlotte,NC,USA,North America
11,Tamara,Tony,Cell Phone,2,1200,3/3/2015,Frankfurt,Hesse,Germany,Europe
10,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
3,Christy,Ladson,TV,3,1600,4/2/2015,High Point,NC,USA,North America
4,John,Rivers,Laptop,5,2400,3/9/2014,Jersey City,NJ,USA,North America
4,John,Rivers,Laptop,5,2400,3/9/2014,Jersey City,NJ,USA,Africa
SQL Tables for Demo
CREATE TABLE [dbo].[TotalSale] (
[id] [int] not null
,[SalePersonFName] [varchar](100) NOT NULL
,[SalePersonLName] [varchar](100) NOT NULL
,[ProductName] [varchar](100) NULL
,[ItemsSold] [int] NULL
,[SoldPrice] [float] NULL
,[SoldDate] [date] NULL
,[City] [varchar](100) NULL
,[State] [varchar](100) NULL
,[Country] [varchar](100) NULL
,[Region] [varchar](100) NULL,
FileName varchar(100)
)
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
