RE: artificial values vs null
- From: STEVE OLLIG <sollig@xxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 24 Sep 2004 09:19:20 -0500
I love that solution! can our companies work a trade - you for one of our
seasoned DWHers? serves me right for not foresaking sleep in favor of
reading Kimball when i took this assignment ;)
we use a surrogate key on all dimensions except time. silly us.
thanks!
>
> We use a surrogate key (integer) for the key of the time
> (date) dimension in
> our datamart - saves space.In theory we we can distinguish
> between "date to
> be determined", "date not applicable" (see the datawarehouse toolkit -
> kimball 2nd ed). The key is is never null (but the date is).
>
>
> chaim
> http://www.learntorah.net
>
>
>
> -----Original Message-----
> From: STEVE OLLIG [mailto:sollig@xxxxxxxxxxxxx]
> Sent: Friday, September 24, 2004 9:45 AM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: RE: artificial values vs null
>
>
> I'm not a NULLophobe (one who fears NULLs)
--
//www.freelists.org/webpage/oracle-l
Other related posts:
