CODEWITHSUNDEEP
azureazure-data-factorydataflow
ZCoder
ZCoder

Reputation: 2339

How to use merge functionality in data flow azure

I know we can use Joins but i am having issues let me explains.

If i have a CSV file which have some data and there is row which have these values

ID:3 ,Name:Sam ,Role 2

Now the Data Source have the same data but name has been change from Sam to Man

ID:3 ,Name:man ,Role 2

In SSIS we use Merge which update the record.As i am learning Data Flow I have no idea What to use here

CSV-->Join-- Sink ?

Upvotes: 0

Views: 86

Answers (1)

Mark Kromer MSFT
Mark Kromer MSFT

Reputation: 3838

In ADF Data Flows, Join will be the most natural transformation to use here.

Kamil Nowinski put together a nice cheat sheet for ADF-to-SSIS data flow translations: https://sqlplayer.net/2018/12/azure-data-factory-v2-and-its-available-components-in-data-flows/

Upvotes: 1

Related Questions