Comment by Duke Ganote on Foreign Keys in a Data Mart

I’m curious how you deal with gaps in referential integrity: our ETL team coined the phrase “shoring up the dimensions” when referring to the dummy records I require to be built. (BTW, since the dummy records are ETL-created, I didn’t have any issues with ETL-enforced integrity — until I found not everyone was “rabid about referential integrity”).

!***! Entry Link: Foreign Keys in a Data Mart!***!

You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

Comments are closed.