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

Рет қаралды 29,333

4 жыл бұрын

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

Пікірлер: 38

@hamzax233 10 ай бұрын

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

@monikadubey5825 3 жыл бұрын

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

@vijayashreesuriyanarayanan1184 2 жыл бұрын

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

@rajuthatikonda8921 2 жыл бұрын

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

@sachinchavan9348 3 жыл бұрын

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 3 жыл бұрын

Yes sir please

@insane2093 2 жыл бұрын

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

@MounikaJ-ht3uu 3 ай бұрын

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

@nitishsalunke 2 жыл бұрын

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

@syedmukram7184 4 жыл бұрын

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

@vikasswain4434 4 жыл бұрын

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

@amarnadhg6896 4 жыл бұрын

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 4 жыл бұрын

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

@kumrasudhir 3 жыл бұрын

Do you have an example of UpsertIf? Thanks in Advance

@vinothrajendran858 3 жыл бұрын

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?

@Anonymous-cj4gy 3 жыл бұрын

@RanjithKumar-jj5zi 4 ай бұрын

did you got the answer?

@vigneshr8956 2 жыл бұрын

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

@omkarmhaiskar419 3 жыл бұрын

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?

@rockseerock 2 жыл бұрын

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

@vikasswain4434 4 жыл бұрын

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 4 жыл бұрын

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

@vikasswain4434 4 жыл бұрын

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

@WafaStudies 4 жыл бұрын

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

@vikasswain4434 4 жыл бұрын

@@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.

@vigneshmurali1994 3 жыл бұрын

Kindly make sure to keep video within 10 mts

@debasissarangi5169 2 жыл бұрын

how do u create sampledb?

@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

@tanushreenagar3116 3 жыл бұрын

I am troubling while making dataset in this sql please help

@WafaStudies 3 жыл бұрын

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

@tanushreenagar3116 3 жыл бұрын

@@WafaStudies thnks

@mainuddinali9561 7 ай бұрын

plz add dataset aslo

@mirzabaig6713 3 жыл бұрын

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 2 жыл бұрын

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

@malachiaxl3178 2 жыл бұрын

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

@fabianmalcolm6511 2 жыл бұрын

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