Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Building fact tables in a data warehouse
This looks like a long process.
Have you consider using a primary key that contain the primary key
fields + the fields that you need to go to the next table.
This way you will eliminate going to the table itself.
Adar Yechiel
Rechovot, Israel
Thomas Day wrote:
> I'm just wondering if anyone has any insights on how to speed this up.
>
> Our fact tables consist of the primary keys of the involved dimension
> tables plus numeric count columns.
>
> To build our fact table, let's call it Z (as I understand the
> process) we grab the primary key of the row in dimension A plus
> information which
> we can use to find the associated row in dimension B. We go to
> dimension B, grab the primary key plus information which allows us to
> find the associated row in dimension C, and so on through 8 dimension
> tables.
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 26 2007 - 11:04:39 CST
![]() |
![]() |