Re: Looking for table design input

From: Amar Kumar Padhi <amar.padhi_at_gmail.com>
Date: Sat, 28 Mar 2009 00:45:02 +0400 (GST)
Message-ID: <21692798.29031238186926849.JavaMail.seven_at_aomfe2p1>

it is ok to retrieve data for query purpose from a FACT (through a dimension) to an online processing screen, as long as this does not require the retrieved data to be updated also. I have seen such setup and in effect FACT query proved to be much cheaper than online table access, as data is already summarized and pre-computed for reporting. This could be true for your case also, but needs to be determined case to case.

And for clarity sake, we follow standards not to mix online access with data mart objects, this is to avoid any kind of wrong usage. But as an exception we allowed it in few sceens as we could see significant benefit in performance.

Thanks!
Amar
Www.amar-Padhi.com

-original message-

 Re: Looking for table design input
From: genegurevich_at_discover.com
Date: 28-03-2009 00:15

Amar:

This table does look like a fact table, but it will be part of the

--

http://www.freelists.org/webpage/oracle-l Received on Fri Mar 27 2009 - 15:45:02 CDT