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

[@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