Aprenda Azure Data Factory Real Time Scenarios gratuitamente com 49 vídeo(s). Curso online grátis de Azure Data Factory | YouCourse.
Aulas do Curso
(49 vídeos)
0 de 49 aulas concluídas
0%
Progresso salvo somente neste navegador.
0
1. Handle Error Rows in Data Factory Mapping Data Flows
In this video, I discussed about Handling Error Rows in data in Data factory mapping data flows.
Link for Azure Functio…
1
2. Get File Names from Source Folder Dynamically in Azure Data Factory
In this video, I discussed about Getting File Names Dynamically from Source folder in Azure Data Factory
Link for Azure…
2
4. Delete old files from storage using Azure Data Factory
In this video, I discussed about how to delete old files from storage dynamically using azure data factory
Link for Azu…
3
3. Incrementally copy new and changed files based on Last Modified Date in Azure Data Factory
In this video, I discussed about Incrementally copy new and changed files based on Last modified date in Azure data fact…
4
5. Process fixed length text files by Azure Data Factory mapping data flows
In this video, i discussed about processing fixed length text files by Azure Data Factory mapping data flows.
Link for …
5
6. Log Pipeline Executions to SQL Table using Azure Data Factory
In this video, I discussed about logging pipeline execution details to SQL Table using Azure Data Factory
Link for Azur…
6
7. Remove Duplicate Rows using Mapping Data Flows in Azure Data Factory
In this video, i discussed about Removing duplicate rows using Mapping Data Flows Or getting distinct rows using mapping…
7
8. Increment Keys from Existing Source Using Mapping Data Flow in Azure Data Factory
In this video, i discussed about using Surrogate key transformation and incrementing keys from existing source using map…
8
9. Running Total using Mapping Data Flow in Azure Data Factory
In this video, i discussed about Calculating Running Total using Mapping Data Flows in Azure Data Factory
Link for Azur…
9
10. Log Pipeline Executions to file Using Mapping Data Flows in Azure Data Factory
In this video, I discussed about Logging Pipeline Executions to File using Mapping data flows in Azure Data Factory
Lin…
10
11. Slowly Changing Dimension(SCD) Type 1 Using Mapping Data Flow in Azure Data Factory
In this video, I discussed about Slowly changing Dimension Type1 using mapping data flows in azure data factory
Link fo…
11
12. Get Count of Files in Folder using Azure Data Factory
In this video, I discussed about getting count of files from folder using Azure Data Factory
#Azure #AzureDataFactory #…
12
13. Add additional columns during copy in Azure Data Factory
In this video, I discussed about adding additional columns during copy in Azure Data Factory
#Azure #ADF #AzureDataFac…
13
14. Convert Array to String in Azure Data Factory
In this video, I discussed about converting array to string in Azure Data Factory
Link for Python Playlist:
https://www…
14
15. Join() function to convert Array to String in Azure Data Factory
In this video, I discussed about join() function to convert array to string in azure data factory
Link for Python Playl…
15
16. Validate file schema before processing in Azure Data Factory
In this video, I discussed about Validate file schema before processing in Azure Data Factory
Link for Python Playlist:…
16
17. Slowly Changing Dimension(SCD) Type 2 Using Mapping Data Flow in Azure Data Factory
In this video, I discussed about SCD type 2 implementation using mapping data flow in Azure Data Factory
Link for Azure…
17
18. Copy multiple tables in bulk by using Azure Data Factory
In this video, I discussed about Copying multiple tables from SQL Database in bulk to Azure blob storage using Azure Dat…
18
19. Execute Stored Procedure with Output Parameter in Azure Data Factory
In this video, I discussed about executing stored procedure with output parameter in Azure Data Factory
Link for Azure …
19
20. Get Latest File from Folder and Process it in Azure Data Factory
In this Video, I discussed about how to get latest file from folder and process it in Azure Data Factory
Link for Azure…
20
21. Dynamic Column mapping in Copy Activity in Azure Data Factory
In this video, I discussed about how to perform column mapping dynamically in copy activity in Azure data factory
Link …
21
22. Merge Multiple rows in to Single row using Mapping data flow in Azure Data Factory
In this video, I discussed about how to merge multiple rows in to single row using mapping data flow in azure data facto…
22
23. Send Email alert when Pipeline fails in Azure Data Factory
In this video, I explained about creating a logic app which will run on HTTP request and send email alert, and calling t…
23
24. Split Single row into Multiple rows using Mapping Data Flows in Azure Data Factory
In this video, I explained how to split single row into multiple rows using mapping data flow in azure data factory
Lin…
24
25. Download file from API and load it in to Sink using Azure Data Factory
Link used to download file:
https://file-examples-com.github.io/uploads/2017/02/file_example_XLSX_5000.xlsx
In this vid…
25
26. Download Zip file from API and load all unzipped files to Sink Using Azure data factory
API link used to download zip file:
https://file-examples-com.github.io/uploads/2017/02/zip_2MB.zip
In this video, I di…
26
27. Round decimal number in Pipeline expression in Azure Data Factory
In this video, I discussed about rounding decimal number in pipeline expressions in Azure data factory
Link for Azure S…
27
28. TimeZone Conversion in Mapping Data Flows in Azure Data Factory
In this video, I discussed about how to perform time zone conversion in mapping data flows in Azure data factory
Link f…
28
29. Run an activity if any one of set of activities fail in Azure data factory
In this video, I discussed about running an activity on failure of any one of set of activities in Azure data factory
L…
29
30. Get Error message of Failed activities in Pipeline in Azure Data Factory
In this video, I discussed about getting error message details of failed activities in pipeline in azure data factory
Pl…
30
31. Run Pipeline of one ADF from another ADF using Web Activity
In this video, I discussed about running Pipeline of one Azure data factory from another data factory using web activity…
31
32. Copy data from REST API which sends response in Pages using Azure data factory
In this video, I discussed about how to make REST API call which supports paginations and store response in to files or …
32
33. Load CSV file in to JSON with Nested Hierarchy using Azure data factory
In this video, I discussed about loading csv file as Json with nested hierarchy using azure data factory mapping data fl…
33
34. Dynamically pass expressions into Data flow transformations in Azure data factory
In this video, I discussed about how to dynamically pass expressions in to data flow transformations in Azure data facto…
34
35. Compare source data with target data using data flows in Azure data factory or Azure Synapse
In this video, I discussed about comparing data between source and target using data flows in Azure data factory or Azur…
35
36. Execute SQL queries using Lookup activity in Azure data factory
In this video, I discussed about Executing SQL queries using lookup activity in Azure data factory
Link for Azure Synap…
36
37. Check its weekday or not in Pipeline execution in Azure Data factory
In this video, I discussed about checking given day as weekday or weekend using contains() function and dayOfweek() func…
37
38. Execute Azure Data Factory Pipeline from Logicapp
In this video, I discussed about executing Azure data factory pipeline from Logicapp.
Link for Azure Synapse Analytics …
38
39. How to Capture Changed Data using Data flows in Azure Data Factory
In this video, I discussed about how to capture changed data using data flows in Azure Data Factory
Link for Azure Syna…
39
40. Working with Token based REST API in Azure Data Factory
In this Video, I discussed about working with REST API with token authentication in Azure data factory.
REST API websit…
40
41. Compare file names of source and sink folders to get missing file names in Azure Data Factory
In this video, I discussed about comparing file names between source and sink to get missing file names in Azure Data fa…
41
42. Read all files in a folder as a single source in to Mapping data flows in Azure Data Factory
In this video, I discussed about reading data from multiple files as single source dataset in to mapping data flows in A…
42
43. Write dynamic expression for SQL with single quotes around parameter value in Mapping data flows
In this video, I discussed about how to write dynamic expression for SQL query in mapping data flows where you want to s…
43
44. Delete Files Which are less than Specific Size in a Folder using Azure Data Factory
In this video, I discussed about deleting files which are less than 100 bytes in a folder using Azure Data Factory.
Lin…
44
45. Iterate over excel file sheets dynamically and copy them as a CSV file using Azure Data Factory
In this video, I discussed about Iterating over excel file sheets dynamically using sheet index and copying them as sepa…
45
46 Not allow edits on Collaboration Branch in Azure Data Factory | #datafactory #azuredatafactory
In this video, I discussed about settings in DevOps branches which will stop users to perform edits on branches. Especia…
46
47. Partition Source data by columns and store in hierarchy path in Sink using Mapping Data flows
In this video, I discussed about how to partition source data by columns and store them in hierarchy paths in sink stora…
47
48. How to Copy data from REST API to Storage account using Azure Data Factory | #adf #datafactory
In this video, I discussed about how to copy data from REST API to ADLS gen2 storage account or SQL table using Azure da…
48
49. Update ADF environment by importing ARM template | #adf #datafactory #azure #azuredatafactory
In this video, I discussed about updating ADF environment same as other ADF environment by importing ARM template.
Link…