Do Data Warehouse standards allow foreign key constraints at a dimensional model?

404

rajneesh4u

posted on 07 May 20

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds




nVector08-May-20

Performance!  Data Warehouses ingest millions of rows everyday.  And having constraints like Primary Key / Foreign Key is a real killer. It hurts the load performance and also causes hectic maintenance, to constantly monitor and respond to failures. Its good and bad though)

Remember, all the modern data warehouse platforms (Snowflake / Bigquery), do not even have an option to create constrains / enforce them on the tables

rajneesh4u08-May-20

Thank you !!!