25. Using IDENTITY to create surrogate keys using dedicated SQL pool in Azure Synapse Analytics

In this video, I discussed about using IDENTITY to create surrogate keys using dedicate sql pool in azure synapse analytics
Link for Azure Synapse Analytics Playlist:
• 1. Introduction to Azu...
Link for Azure Data bricks Play list:
• 1. Introduction to Az...
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...
Link for Azure Data Factory Real time Scenarios
• 1. Handle Error Rows i...
Link for Azure LogicApps playlist
• 1. Introduction to Azu...
#Azure #AzureSynapse #AzureSynapseAnalytics

[@annukumari9629]

Thanks for the detailed analysis. Very helpful .

[@WafaStudies]

Welcome 🤗

[@purandarreddy-vp8dy]

1st viewer. 😊 Thankyou very much for sharing your knowledge to us.

[@WafaStudies]

Ya. Thank you 😊

[@naveenkantem3831]

Super and great content Master 👏👏

[@WafaStudies]

Thank you 😊

[@shubhamkumar-xv3cv]

What if we use Replicate Distribution then how the value for the column would be decided?

[@venkatasai4293]

I have a doubt here. A distribution will be further divided into multiple partitions?

[@gayathriarras6506]

A Small doubt In sql two null values will not be the same right , in dedicated sql pool will not be the same condition as SQL ?

[@MyJuit]

yes it is same as SQL