Re: Looking for table design input
Date: Fri, 27 Mar 2009 15:10:52 -0500
Message-ID: <OFF6B8B6B1.4EBAD561-ON86257586.006EC532-86257586.006EDE47_at_discover.com>
Amar:
This table does look like a fact table, but it will be part of the
curstoer-facing online system. The users will need to be able to retrieve
all the data
per a specific ID
thank you
Gene Gurevich
Amar Kumar Padhi <amar.padhi_at_gmail .com> To <genegurevich_at_discover.com> 03/27/2009 02:32 cc PM <oracle-l_at_freelists.org> Subject Re: Looking for table design input
Hi Gene,
From the look of it, the table represents a FACT table of a star schematic
design, I am just guessing here. If the table is part of warehouse or
intended for reporting purpose, then the design is probably applicable,
provided you have proper dimension tables in relation to this table.
normalizing it will not be a good thing to do if such is the case.
Thanks!
Amar
Www.amar-Padhi.com
-original message-
Re: Looking for table design input
From: genegurevich_at_discover.com
Date: 27-03-2009 23:13
At this point I am trying to do now is to compe up with an initial design.
Please consider the environment before printing this email.
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 27 2009 - 15:10:52 CDT