RE: artificial values vs null

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_at_lifetouch.com]
> Sent: Friday, September 24, 2004 9:45 AM
> To: oracle-l_at_freelists.org
> Subject: RE: artificial values vs null
>
>
> I'm not a NULLophobe (one who fears NULLs)

--
http://www.freelists.org/webpage/oracle-l