Re: Looking for table design input
- From: Amar Kumar Padhi <amar.padhi@xxxxxxxxx>
- To: <genegurevich@xxxxxxxxxxxx>
- Date: Sat, 28 Mar 2009 00:45:02 +0400 (GST)
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-
Subject: Re: Looking for table design input
From: genegurevich@xxxxxxxxxxxx
Date: 28-03-2009 00:15
Amar:
This table does look like a fact table, but it will be part of the
--
//www.freelists.org/webpage/oracle-l
Other related posts:
