hard20 pts · first answer countsdata-modellingscdconstraints
Only one current SCD2 row
In PostgreSQL, how can you make sure a type 2 dim_customer never has two current rows for the same customer_id?
Discussion 0
Join free to post in the discussion.
Related questions
- SCD type that overwritesData Engineer
- Primary key for order linesData Engineer
- Modelling doctors and patientsData Engineer
- Several phones in one columnData Engineer
- Several unique columnsData Engineer
- Picking the natural keyData Engineer
- Reading crow's foot notationData Engineer
- The model with indexes and typesData Engineer