sunilreddy

• Mar 17th, 2006

 

A fact table consists of measurements of business requirements and foreign keys of dimensions tables as per business rules.

venkat

• May 13th, 2006

 

Basically the fact table consists of the Index keys of the dimension/ook up tables and the measures.

so when ever we have the keys in a table .that itself implies that the table is in the normal form.

Thanks

venkat

KPIZME

 Profile Answers by KPIZME Questions by KPIZME

• May 23rd, 2006

 

I somewhat disagree venkat.  There can just be SKs within a Star schema, which itself is de-Normalized.  Now, if there are then FKs on the dimensions as well, I would agree.

andy

• Jun 23rd, 2006

 

Being in normal form, more granularity is achieved with less coding i.e. less number of joins while retrieving the fact.

srinivas

• Sep 27th, 2006

 

To eliminate the redundency

sreek

• Nov 29th, 2006

 

Srinivas your right  simple and good answer keep it up.

Sanjeev

• Mar 26th, 2007

 

The Fact table is central table in Star schema, Fact table is kept Normalized because its very bigger and so we should avoid redundant data in it. Thats why we make different dimensions there by making normalized star schema model which helps in query performance + to eliminate redundant data....

~~ Cheers
Sanjeev

j123

• Jun 9th, 2013

 

Foreign keys of facts tables are primary keys of Dimension tables. It is clear that fact table contains columns which are primary key to other table that itself make normal form table.

kamesh

• Jan 30th, 2018

 

Basically Fact table contain Index keys of the dimension/lookups tables of the measures so when ever we have the keys in the table it implies itself the fact table is in Normal For.