Re: quick FK question
From: Rumpi Gravenstein <rgravens_at_gmail.com>
Date: Mon, 21 Dec 2009 08:01:13 -0500
Message-ID: <9c9b9dc90912210501n6d405esb9c473ed1b7d8971_at_mail.gmail.com>
<snip>
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.
</snip>
Date: Mon, 21 Dec 2009 08:01:13 -0500
Message-ID: <9c9b9dc90912210501n6d405esb9c473ed1b7d8971_at_mail.gmail.com>
<snip>
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.
</snip>
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 -- http://www.freelists.org/webpage/oracle-lReceived on Mon Dec 21 2009 - 07:01:13 CST