Re: quick FK question
Date: Mon, 21 Dec 2009 10:51:58 -0300
Having garbage data is no solution to flawed design? Having to worry about code quality is no excuse to have garbage data? Punch him in the face, revoke his create privileges and tyrannically remove the not null from FK columns ;-)
Ask for evidence (an oracle white paper, a book by a known author) of this claim.
On Mon, Dec 21, 2009 at 10:01 AM, Rumpi Gravenstein <rgravens_at_gmail.com>wrote:
> I've seen once from some duhvelopers - they created all FK columns NOT
> NULL. Unfortunately of course there were cases with FK columns where
> actual value could not be provided. So what did they do? An obvious
> solution! ;) Added one row with id = -1 as a stub to all db tables.
> Gints I wanted to follow-up on this statement as our warehouse data
> modeler insists on doing this for all dimension joins claiming that
> this is good warehouse design as it avoids having to worry about outer
> joins. How would you respond?
> Rumpi Gravenstein