Re: Unindexed FK and DW

From: EscVector <Junk_at_webthere.com>
Date: 7 Nov 2006 08:53:04 -0800
Message-ID: <1162918384.840607.307320@b28g2000cwb.googlegroups.com>

There are two popular model approached, Inman and Kimball. Inman promotes normal-form warehouses, Kimbal promotes fact and dimensions.

Inman = PK/FK
Kimbal = Fact/Dimension PK/FK optional

the above is very simplified.

With Oracle, if you have a PK on partitioned fact table, you will encounter multiple issues reorganization of global indexes and issues with locking on dimension tables.

It is neither common or uncommon. It really depends on the data model.

klabu wrote:
> Is Unindexed FK a common thing in Data Warehouse ?
>
> thanks
>
> 10gR2
Received on Tue Nov 07 2006 - 10:53:04 CST