Is fact table normalised or denormalised or partially normalised?

Question

How would you categorise fact table in Data warehouse ? Is fact table normalised or denormalised or partially normalised.

http://stackoverflow.com/questions/22703985/fact-table-is-in-normalized-or-de-normalized-form/22746286#22746286 — Damir Sudarevic, Sep 29 '14 at 10:22

score 0 · Answer 1 · answered Sep 26 '14 at 18:35

0

I will quote wikipedia:

Fact tables are often defined by their grain. The grain of a fact table represents the most atomic level by which the facts may be defined.

Fact table (a measure holder table in star/snowflake schema) is denormalised.

answered Sep 26 '14 at 18:35

fenix

1 Answers1