Joining Queries in Azure Data Factory on Cosmos DB Sources
This article shows how you can use two Cosmos DB dataets in Azure Data Factory and join them on a common column.
2024-04-08
783 reads
This article shows how you can use two Cosmos DB dataets in Azure Data Factory and join them on a common column.
2024-04-08
783 reads
In this article, we look at how you might go about choosing whether to use SSIS or ADF for your next ETL/ELT project.
2024-04-01
Learn how to use Azure Data Factory to dynamically move bulk data from multiple sources to a new destination using the ForEach and Lookup activities.
2024-03-04
Learn how a C# script can easily load data from Excel into SQL Server.
2024-01-15
6,105 reads
The ForEach loop works with only one file type at a time by default. Learn how you can add code to your packages to work with multiple types of files.
2023-12-18
2,072 reads
Learn how you can return data from one ADF pipeline for use in another.
2023-11-01
2,040 reads
Learn how you can configure an Azure Data Factory pipeline that is triggered by an email being sent to an address.
2023-11-03 (first published: 2023-10-27)
2,581 reads
Extraction Transformation Load (ETL) is the backbone for any data warehouse. In the data warehouse world data is managed by the ETL process, which consists of three processes, Extraction-Pull/Acquire data from sources, Transformation-change data in the required format and Load-push data to the destination generally into a data warehouse or a data mart.
2023-10-25
Learn about the evolutionary journey of ETL (Extract, Transform, Load) from traditional processes to modern cloud solutions.
2023-10-18
Learn a step-by-step method to save your ADF pipelines in Git and automatically release new changes to test and production.
2023-10-16
1,839 reads
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
I have been asked to fine-tune the following SQL that was written by a...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
I've tried different credentials, target server versions, etc. hitting our Primavera WSDL. Works great...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers