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
1,151 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
1,151 reads
Learn how to get started with a Microsoft Fabric pipeline.
2023-08-02
4,262 reads
Learn how you can use CI/CD with your ADF Pipelines and Azure DevOps using ARM templates.
2023-03-10
12,165 reads
This article will show how you can use Azure Data Factory to check your data quality with an assertion.
2022-11-02 (first published: 2022-10-24)
3,654 reads
This article discusses the data flow formatters, Flatten, Parse, and Stringify, which can be useful when dealing with JSON data.
2022-08-12
12,480 reads
This article covers how you can give access with a shared key to Azure Storage Accounts and apply a policy for how users can access the files.
2022-06-15
7,846 reads
Get a few common questions and possible answers about Azure Data Factory that you may encounter in an interview.
2022-06-03
4,174 reads
Learn about using the Script activity in Azure Data Factory to run DDL or DML statements.
2022-05-13
16,652 reads
Learn about using Mapping Data Flows in Azure Data Factory.
2022-04-25
6,721 reads
Learn how you can re-use parts of your pipeline in Azure Data Factory. Save off some tasks as a flowlet for use in multiple pipelines.
2024-02-19 (first published: 2022-04-15)
7,103 reads
By Steve Jones
One of the things that I’ve been asked in every operations situation is what...
By Brian Kelley
If you are an introvert like me, events like the PASS Summit can call...
By kleegeek
On October 2nd and 3rd, I took part in an amazing event called AI...
Hello everyone, I’ve developed an SSIS process to compare two relatively large tables. When...
Good afternoon, I have an SSIS package which loads raw records into a sheet...
The setup: 3 tables: core_users, core_roles, and core_user_roles. core users is the "base" table,...
I am building an ETL process between these tables in SQL Server 2022 set to 160 compatibility level:
CREATE TABLE Image_Staging ( imageid INT NOT NULL CONSTRAINT Image_StagingPK PRIMARY KEY , imagestatus TINYINT , imagebinary IMAGE); GO CREATE TABLE Images ( imageid INT NOT NULL CONSTRAINT ImagesPK PRIMARY KEY , imagestatus TINYINT , imagemodified DATETIME , imagebinary IMAGE); GOI want to run this query to check if the images already loaded exist. This will help me decide if I need to insert or update an image. What happens with this query?
SELECT i.imageid FROM dbo.Image_Staging AS ist INNER JOIN dbo.Images AS i ON ist.imagebinary = i.imagebinary;See possible answers