Hello all,
I’m ready to start implementing the ETL from EHR to CDM.But one last little question before I start:How to generate unique id in every table.
There are the following technologies of database：
1.auto_increment
2.Sequence
3.Snowflake
I prefer the first two methods.But I don’t know which is the best choice.So I want to see your best practice.
Thank you.
