63. Window Transformation in Mapping Data Flow in Azure Data Factory

In this video, I discussed about Window Transformation in Mapping Data Flow in Azure Data Factory

Link for Azure Functions Play list:

Link for Azure Basics Play list:

Link for Azure Data factory Play list:

#Azure #ADF #AzureDataFactory

[prabhatracherla]

This might be the easiest and crisp explanation of window aggregation I ever heard.

[sudipmazumdar]

Thanks a lot bro. Awesome Explanation. Initially was a bit confused when someone in comment section mentioned that, this is not how partition works but after going through the video can see that what you explained about the concept is absolutely correct & partition works exactly like this even in sql as well. Would request people to first understand things before commenting. Little knowledge can be a dangerous thing. Now regarding the average, its true that average is not coming correctly for the 3000, 3000, 4000 part but maybe its happening because adf is trying to round off to the nearest value. Maybe some adjustments in expression while calculating average can fix this.

[monibodhuluru]

Is that possible to view column pattern expression in windows expression once saved ?

[rohitsethi]

what is difference between dense rank in window transformation and rank transformation

[krishnadas]

How the rank is performed based on salary without choosing tha rankby column ?

[tusharwalunj]

How the average of IT departments 1st 3 row is coming as 3500?. Average of 3000, 3000 and 4000 should be 3333.33

[sehajshangari]

this is not how the partition works. incorrect example and explanation.