Re: Looking for table design input

From: <genegurevich_at_discover.com>
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

Original text of this message