Basics - why fact table is in normal form?

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Go To First | Previous Question | Next Question

Basics | Question 58 of 112

why fact table is in normal form?

Total Answers and Comments: 7

Last Update: March 26, 2007 Asked by: mallikharjuna reddy

Sponsored Links

Best Rated Answer

—

Submitted by: srinivas

To eliminate the redundency

Above answer was rated as good by the following members:
ranjeet.s

March 17, 2006 06:48:44

sunilreddy

RE: why fact table is in normal form?

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

Is this answer useful? Yes | No

May 13, 2006 04:47:26

venkat

RE: why fact table is in normal form?

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

Is this answer useful? Yes | No

May 23, 2006 22:22:40

KPIZME

Member Since: May 2006 Contribution: 8

RE: why fact table is in normal form?

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.

Is this answer useful? Yes | No

June 23, 2006 05:31:09

andy

RE: why fact table is in normal form?

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

Is this answer useful? Yes | No

September 27, 2006 04:09:11

srinivas

RE: why fact table is in normal form?

To eliminate the redundency

Is this answer useful? Yes | No

1 0

Overall Rating: +1

November 29, 2006 00:51:34

sreek

RE: why fact table is in normal form?

Srinivas your right simple and good answer keep it up.

Is this answer useful? Yes | No

March 26, 2007 00:25:29

Sanjeev

RE: why fact table is in normal form?

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

Is this answer useful? Yes | No

Go To Top