Yes - the right answer. And can be validated with a little basic
normalisation.
peter
edinburgh
Thinking about Matt's question, would it be proper to move
the column to a
EMP_TERMINATED table with an outer join on EMPNO? There
wouldnt be any
NULLs...
Rich
Rich Jesse
');
-Original Message-From:
Grabowy, Chris [mailto:[EMAIL PROTECTED]]Sent: Monday, October 14,
2002 5:11 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: No Nulls? (was: Warehouse design: snowflake vs
star schem
Hmmm...but what about the index? Which is
faster?
select * from
Hey Dick,
Thanks for your response. The reason I ask the question is because I *wish*
our ERP system supported NULLs, at least in date fields. To properly
explain why, I need to preface it with a short explanation:
Our 3rd party ERP system is one that was designed in the '80s using indexed
Rich
If you were to give each of your developers a pop quiz on nulls, how many
do you think would pass? I agree with Dick, that nulls are a confusing
concept that usually only the DBA really understands. I feel that an
important decision when beginning a new application is whether or not to
Title: RE: No Nulls? (was: Warehouse design: snowflake vs star schem
No application that I can reasonably think of should
use NULLS, except those pre-81
where there are obsolete columns.
Everytime somebody says this to me, I ask them:
How do you handle still employed employees
Title: RE: No Nulls? (was: Warehouse design: snowflake vs star schem
END_EMPLOYEMENT date for still employed employees equals to
"01/01/4000" (or any other pre-defined date in distant future).
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From
Title: RE: No Nulls? (was: Warehouse design: snowflake vs star schem
The
problem I see with NO NULLS is that artificial data must be created, where the
data is truly not known. Whether you deal with NULLs or artificial data, you
will always have to code accordingly, so it is a wash. Igor's
Title: RE: No Nulls? (was: Warehouse design: snowflake vs star schem
I disagree with the use of "dummy" values to
represent missing data. It reminds me of the olden days when we coded in
12/31/99 and such. Shades of COBOL HIGH-VALUES! You're introducing a
lot of dependenci
Title: RE: No Nulls? (was: Warehouse design: snowflake vs star schem
Or you'll have to explain to the HR manager why all of the
employees appear to be terminated!
they aren't terminated! at least not yet :-)
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From
49
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
No Nulls? (was: Warehouse design: snowflake vs star schem
The
problem I see with NO NULLS is that artificial data must be created, where the
data is truly not known. Whether you deal with NULLs or artificial data, you
will always ha
Title: RE: No Nulls? (was: Warehouse design: snowflake vs star schem
Actually, you don't have to deal with "01/01/4000" date (at
least on "select"), all you have to do in order find currently employed
employees, is:
where END_EMPLOYMENT sysdate
asfor inserts, all you h
[mailto:[EMAIL PROTECTED]]
Sent: Monday, October 14, 2002 4:49PM
To: Multiple recipients of list ORACLE-L
Subject: RE: No Nulls? (was: Warehouse design: snowflake vs
star schem
Theproblem I see with NO NULLS is that artificial
data must be created, where t
Title: RE: No Nulls? (was: Warehouse design: snowflake vs star schem
This is true. But you still need to add logic
to your application to suppress displaying the termination date when it is =
"01/01/4000". Ican pretty well guarantee your users will not like
seeing a &q
Thinking about Matt's question, would it be proper to move the column to a
EMP_TERMINATED table with an outer join on EMPNO? There wouldnt be any
NULLs...
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex,
other thoughts??
-Original Message-From: Fink, Dan
[mailto:[EMAIL PROTECTED]]
Sent: Monday, October 14, 2002 4:49 PMTo: Multiple
recipients of list ORACLE-LSubject: RE: No Nulls? (was:
Warehouse design: snowflake vs star schem
The pro
15 matches
Mail list logo