Even though we identified several foreign key relationships among our tables, we are not going to create foreign key constraints in our data mart. Foreign key constraints put a strain on the database engine during a large data load. Large data loads are quite common in the data mart environment.
- Chapter 6. Building Foundations—Creating Data Marts
- from Delivering Business Intelligence with Microsoft® SQL Server® 2012, Third Edition
- Publisher: McGraw-Hill
- Released: March 2012
For the data mart that I created for an OLAP cube, my database design included several foreign key relationships for table connections and levels of hierarchies in the dimension tables. However, I did not create foreign key constraints to avoid putting a strain on the database engine in case the ETL process requires large data loads.
Share this highlighthttp://learning.oreilly.com/a/delivering-business-intelligence/21510036/