64. Alter Row Transformation in Mapping Data Flow in Azure Data Factory

In this video, I discussed about Alter Row Transformation in Mapping Data Flow in Azure Data Factory
Link for Azure Functions Play list:
• 1. Introduction to Azu...
Link for Azure Basics Play list:
• 1. What is Azure and C...
Link for Azure Data factory Play list:
• 1. Introduction to Azu...
#Azure #ADF #AzureDataFactory

[@rakshita347]

Superb videos It really understanding n easy to understand

[@rajuthatikonda8921]

Trying to connect to sink table on SQL Server on my machine using the self-hosted IR but it says self-hosted IR is not supported in dataflow. can you please let us know how you connected to your on-premise SQL Server from Azure? Please provide the solution

[@Anonymous-cj4gy]

Trying to connect to sink table on SQL Server on my machine using the self-hosted IR but it says self-hosted IR is not supported in dataflow. can you please let us know how you connected to your on-premise SQL Server from Azure?

[@RanjithKumar-jj5zi]

did you got the answer?

[@monikadubey5825]

Hi, If I need to use all the columns as Key column dynamically from source dataset or last stream, how should I do that?

[@sachinchavan9348]

Can you please show which SQL framework you used to create DB/Table etc...and how you connected from azure to to the SQL?

[@tanushreenagar3116]

Yes sir please

[@nitishsalunke]

Salesforce connector is not available in data flows. What could be the workaround for applying alter row transformation on Salesforce.

[@MounikaJ-ht3uu]

is Alter row transformation is a similar concept to Merge with update, delete, and insert in MS SQL

[@insane2093]

Sir in the sink time u choose dataset with dbemployee what it indicate output file or what

[@amarnadhg6896]

Good video, will you clarify on how key column on sink (Eg.Emp ID)will map exactly source data column Emp ID, if they are in different name on update?

[@WafaStudies]

In the Sink under mappings source column id would have mapped with EmpId column of sink. Mappings should available under third tab or fourth tab of sink I guess.kindly check tabs of sink you will find it

[@mirzabaig6713]

Thanks for the helpful video. What logic do I need to use in Alter Row if Row ( sink) exist but Row (source) doesn't exist then change the value of a field in Row (sink) ? Any help is much appreciated!

[@fabianmalcolm6511]

I realize I'm pretty randomly asking but do anybody know of a good website to watch newly released series online ?

[@malachiaxl3178]

@Fabian Malcolm i dunno I use Flixportal. just search on google after it :D -malachi

[@fabianmalcolm6511]

@Malachi Axl thank you, signed up and it seems like a nice service =) Appreciate it!!

[@vijayashreesuriyanarayanan1184]

Maheer, can you please upload some real time scenarios to work in databricks using SQL, python and dataframes codings?

[@kumrasudhir]

Do you have an example of UpsertIf? Thanks in Advance

[@syedmukram7184]

Good explaination. Is there a way to do incremental loading using data flow?

[@vikasswain4434]

@WafaStudies please make a video on incremental load, type 1 and type 2 SCD

[@vigneshr8956]

Can i use the same dataset for source and sink in mapping data flows?

[@omkarmhaiskar419]

Hello I want to filter data in alter based on date condition. In source i have one date column. So based on that column i have to filter data. Like i want fetch only records which inserted or updated in last 7 days. How can write logic for this? Can you please tell me here?

[@hamzax233]

Great and easy explanation, but "Upsert" not covered, please make a video on that also. Thank you.

[@vinothrajendran858]

Bro. I need a help. I want to join two tables and I need to add a condition where I need to use max () function. How to achieve this?

[@rockseerock]

you said Alter Row TF works with database only but here you worked on .CSV file?

[@debasissarangi5169]

how do u create sampledb?

[@vikasswain4434]

Good content...i am trying this with table as source and table as destination. The conditions does not work...it inserts all the rows.

[@WafaStudies]

Before running it. Try data preview and see if u are getting output as expected.

[@vikasswain4434]

@@WafaStudies the preview shows 100rows inserted, but it should be 1 row

[@WafaStudies]

@@vikasswain4434 u need to use delete if condition to exclude all other rows from getting inserted.

[@vikasswain4434]

@@WafaStudies thanks for helping, I got it working now. A request for making a video on upsert if in alter row transformation, on real life use case.

[@tanushreenagar3116]

I am troubling while making dataset in this sql please help

[@WafaStudies]

Sure. Kindly share details on email or WhatsApp. Will try to help

[@tanushreenagar3116]

@@WafaStudies thnks

[@saileelavamsikrishna]

Bro, I want to update the cells which are having NULL to '' . How is that possible? UPDATE TABLE_NAME SET COLUMN1='' where COLUMN1 IS NULL

[@mohammadrafi2902]

You can use derived transformation to make it blanks for null values

[@vigneshmurali1994]

Kindly make sure to keep video within 10 mts

[@mainuddinali9561]

plz add dataset aslo